New Analysis Wizard: Migration Page
View New Analysis Wizard - Migration Page
The Migration tab is used to specify the database connection to retrieve the query plans for the selected SQL statements from the Adaptive Server instance for the migration in order to analysis the changes in the query plans that result from migrating to a new Adaptive Server instance.
| Item | Description |
|
Name |
Enter a name for this Scenario. |
|
Description |
Enter a description for this Scenario. |
|
Login name |
Enter the name of the login for the destination Adaptive Server instance. |
|
Password |
Enter the password of the login. |
|
Server name |
Enter the database server you are logging into from the drop down field, or enter the name directly. |
|
Use default database and user |
Select this option if you would like to login with the default database and user information and privileges. |
|
Specify database and user |
Select this option if you would like to set the user to one with different credentials or privileges. Enter the database and user. |
Note: The new query plans from the Adaptive Server instance for the migration are compared to the query plans that were retrieved either when the selected SQL was saved or that are retrieved using the current logon.