Skip to content

Get-AzDataMigrationAssessment.md

Latest commit

 

History

History
152 lines (113 loc) · 3.62 KB

Get-AzDataMigrationAssessment.md

File metadata and controls

152 lines (113 loc) · 3.62 KB
external help file
Module Name Az.DataMigration
online version https://learn.microsoft.com/powershell/module/az.datamigration/get-azdatamigrationassessment
schema 2.0.0

Get-AzDataMigrationAssessment

SYNOPSIS

Start assessment on SQL Server instance(s)

SYNTAX

CommandLine (Default)

Get-AzDataMigrationAssessment -ConnectionString <String[]> [-OutputFolder <String>] [-Overwrite] [-PassThru]
 [<CommonParameters>]

ConfigFile

Get-AzDataMigrationAssessment -ConfigFilePath <String> [-PassThru] [<CommonParameters>]

DESCRIPTION

Start assessment on SQL Server instance(s)

EXAMPLES

Example 1: Run SQL Assessment on given SQL Server using connection string

Get-AzDataMigrationAssessment -ConnectionString "Data Source=LabServer.database.net;Initial Catalog=master;Integrated Security=False;User Id=User;Password=password" -OutputFolder "C:\AssessmentOutput" -Overwrite
Starting SQL assessment...
Progress: 100%; Issues Found: 100; Objects Assessed: 500/500; Status: Completed; Total time: 00:01:50.000.

Finishing SQL assessment...
Assessment report saved to C:\Users\user\AppData\Local\Microsoft\SqlAssessment\SqlAssessmentReport.json.
Event and Error Logs Folder Path: C:\Users\user\AppData\Local\Microsoft\SqlAssessment\Logs

This command runs SQL Assessment on given SQL Server using the connection string.

Example 2: Run SQL Assessment on given SQL Server using assessment config file

Get-AzDataMigrationAssessment -ConfigFilePath "C:\Users\user\document\config.json"
Starting SQL assessment...
Progress: 100%; Issues Found: 100; Objects Assessed: 550/550; Status: Completed; Total time: 00:01:50.000.

Finishing SQL assessment...
Assessment report saved to C:\Users\user\AppData\Local\Microsoft\SqlAssessment\SqlAssessmentReport.json.
Event and Error Logs Folder Path: C:\Users\user\AppData\Local\Microsoft\SqlAssessment\Logs

This command runs SQL Assessment on given SQL Server using assessment config file.

PARAMETERS

-ConfigFilePath

Path of the ConfigFile

Type: System.String
Parameter Sets: ConfigFile
Aliases:

Required: True
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-ConnectionString

Sql Server Connection Strings

Type: System.String[]
Parameter Sets: CommandLine
Aliases:

Required: True
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-OutputFolder

Output folder to store assessment report

Type: System.String
Parameter Sets: CommandLine
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Overwrite

Enable this parameter to overwrite the existing assessment report

Type: System.Management.Automation.SwitchParameter
Parameter Sets: CommandLine
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-PassThru

Type: System.Management.Automation.SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

CommonParameters

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

INPUTS

OUTPUTS

System.Boolean

NOTES

RELATED LINKS