Migration Manager for AD 8.15 - Resource Processing Guide

Step 5. Select SQL Server

Use the Add button to add the SQL servers to be processed by this task. The Add SQL Server dialog box will appear. In this dialog box, either type the server name in the text box or use the Browse button to select the server from the list.

You can select either Windows integrated authentication or SQL Server authentication. If SQL Server authentication is selected, enter the login ID and the password, and then click OK.

Use the Remove button to remove servers from the list. To change the credentials for a server, select the server in the list and click the Properties… button. Specify the new credentials in the SQL Server Properties dialog box.

Step 6. Specify Scheduling Options

This step allows you to specify whether the task should be started immediately or scheduled.

• Save and start processing immediately—Select this option to start the task immediately after you finish the wizard. To view the task execution progress, select the task object in the project tree and switch to the Information tab in the right-hand pane.
• Save task configuration—Select this option to save the task configuration. You can start the task any time later by right-clicking it in Migration Manager and selecting Start from the shortcut menu.
• Save and schedule processing—Select this option if you want to specify the time when the task should be started. You can schedule the task to be performed, for example, during the night. Click the Schedule… button to specify the time.

Step 7. Complete the SQL Processing Wizard

In this step, the wizard displays all the settings you made in the previous steps. You can print these settings for later review by clicking the Print button and then selecting the printer. You can also save the settings in a text file by clicking the Save As button and specifying the filename.

Click Finish to complete the SQL Processing Wizard. The new SQL processing task will appear under the Tasks container in the Migration Project tree.

Running SQL Update

To start an SQL processing task from Migration Manager, select the task in the project tree, right-click the task, and select the Start command from the shortcut menu.

To view the task execution progress, select the task object in the project tree and switch to the Information tab in the right-hand pane.

Stopping a Task

If for some reason you want to interrupt SQL processing, right-click the task and select the Stop command from the shortcut menu.

If you stop processing by selecting the Stop command, or the task execution is stopped due to an error, the task acts as follows:

• If you stop the task during permissions update, further re-permissioning will be stopped. Objects already processed by that moment will have new (target) permissions. Objects not yet processed will keep old permissions. If you want to completely restore the SQL state, run the wizard with the Revert to the original object ownership and permissions option.
• If you stop the task while reverting changes, further re-permissioning will be stopped. Objects already processed by that moment will have source permissions. Objects not yet processed will keep target permissions. If you want to restore the SQL state, run the wizard with the Reassign object ownership and permissions to target users option.
• If you stop the task during cleanup of permissions, further processing will be stopped. Permissions of the objects already processed by that moment will be cleaned up. Objects not yet processed will be left intact.

Log File

The SQL Processing Wizard log is stored in the SQLWiz.log file.

Reconfiguring a Task

To reconfigure the task, right-click the task object and select Properties. The SQL Processing Wizard will start and let you specify different options for the task. Refer to the steps above for more information on the options.