Invoke-DevartFindInvalidObjects

Synopsis

Detects invalid objects.

Description

Use the cmdlet to search for and detect invalid objects in multiple databases, and to analyze them and generate reports on the results.

Syntax

Invoke-DevartFindInvalidObjects -Connection <object> [-Database <string>] [-Alldatabases <SwitchParameter>] [-Log <string>] [-Report <string>] [<CommonParameters>]

Parameters

-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.

Outputs

System.Boolean (returns true on success and false otherwise)

Examples

Invoke-DevartFindInvalidObjects -Connection $connection -Database "AdventureWorks2019_Dev, AdventureWorks2019_Test"

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge DevOps Automation for SQL Server.
Request a demo

Request a demo

If you consider employing the DevOps Automation for your business, request a demo to see it in action.
Ready to start using dbForge DevOps Automation for SQL Server?