Detects invalid objects.
Use the cmdlet to search for and detect invalid objects in multiple databases, and to analyze them and generate reports on the results.
Invoke-DevartFindInvalidObjects -Connection <object> [-Database <string>] [-Alldatabases <SwitchParameter>] [-Log <string>] [-Report <string>] [<CommonParameters>]
-Connection <object>
Specifies a connection to the server in which database you will search for invalid objects.
This can be:
an instance of a DevartDatabaseConnectionInfo object produced by the New-DevartSqlDatabaseConnection cmdlet.
a database connection string.
Required? true
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-Database <string>
Specifies a single database or multiple databases separated by commas.
The option overrides the values specified in the connection parameter.
Required? false
Position? named
Accept pipeline input? false
Accept wildcard characters? false
Alldatabases <SwitchParameter>
Finds invalid objects for all non-system databases specified in the connection parameter.
Required? false
Position? named
Default value false
Accept pipeline input? false
Accept wildcard characters? false
-Log <string>
Specifies a path to save a log file.
Required? false
Position? named
Accept pipeline input? false
Accept wildcard characters? false
-Report <string>
Generates a report in the CSV file format. Specify a path to save the report file.
Required? false
Position? named
Accept pipeline input? false
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the following common parameters: Verbose, Debug, ErrorAction, ErrorVariable, WarningAction, WarningVariable, InformationAction, InformationVariable, OutBuffer, PipelineVariable, and OutVariable. For more information, see About CommonParameters.
System.Boolean (returns true on success and false otherwise)
Invoke-DevartFindInvalidObjects -Connection $connection -Database "AdventureWorks2019_Dev, AdventureWorks2019_Test"