Then complete the Source Login window:
Authentication Method. Select the desired authentication method to connect to the SQL Server instance. See SQL Server Books Online for additional details regarding Windows versus SQL authentication.
User Name. Enter the appropriate user name. (This value is needed only if SQL Server Integrated Security is selected as the Authentication Method.)
Password. Enter the user's password, and then
When you have completed your entries, click Test Connection to verify the credentials. This step must be completed before moving to the next step in the migration.
Target Login window
On the Target Login window, enter the SQL login information needed to connect to the target SQL Server instance.
14 | Using MxMigrate |