Chat now with support
Chat with Support

Migration Manager for AD 8.15 - Resource Processing Guide

Introduction to Resource Update Distributed Updates in Resource Updating Manager Common Resource Update Workflows Active Directory Processing Exchange Server Processing SMS Processing SQL Server Processing Cluster Server Migration Command-Line Resource Update SharePoint Processing

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.

Caution: The login used to process the SQL Server must be a member of the sysadmin role.

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.

Caution: If the SQL server agent is not running while the SQL server is being updated, a warning message will be displayed. If this message appears in the case of a running agent, then some tasks may not work properly. Restarting the SQL server agent is recommended.

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.

Caution: If you access SQL Server as a member of the local group (for example, BUILTIN\Administrators), you should process the local groups on the source domain controller with Resource Updating Manager to make the newly-created accounts members of these groups. In that case, the local groups must be excluded from processing by the SQL Processing Wizard.

Related Documents