Performance issues within SQL Data Compare

If you are stuck during deploying, you may want to save the deployment script to a file, copy it over to the target SQL Server and run it locally using a SQL query utility such as Management Studio. You can save the script by selecting 'save script' on the last stage of the Deployment Wizard instead of clicking Deploy Now.

Review the options for comparison behaviors like filtering the data (you compare only the data you are really interested in, and the size of the temporary files is reduced), clear the Show identical values in results check box and if you are comparing tables with large amounts of data that changes infrequently, select the Use checksum comparison.

Selecting a subset of rows to deploy at a time.

Consider using the command line interface (Professional Edition only) to create a comparison and deployment command and schedule it to run at a time when the SQL server is experiencing least activity.

More options:

https://documentation.red-gate.com/sdc13/troubleshooting/error-messages/troubleshooting-system-outofmemoryexception-during-comparison

Was this article helpful?

0 out of 0 found this helpful
Have more questions? Submit a request