Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

After reviewing the synchronization script and making sure that the script will do does what you intend it to do, you can execute it.

Warning

...

This action

...

makes permanent changes to the content of the target database. It is common sense and we strongly recommend that before executing the script you:

  • Make a full backup of the target

...

  • schema. Keep in mind that if columns or tables that contain data will be dropped by the synchronization script the only way to reverse the changes will be to restore the data from a full backup of the database.
  • Save the script you are about to execute so that you know exactly what was done to the database and when.

You can execute the script directly from IDERA SQL Schema Compare SSMS and execute it from there. Please pay attention to the Action section on the header of the synchronization script to make sure that the script will be executed against the correct database.

Note that by default, the synchronization script will be executed within a transaction so if you cancel the execution of the script before it completes the transaction will roll back and undo all the changes that were done up to that point. Therefore, the cancellation of the script execution is not instantaneous as depending on the scenario it may take significant amount of time to roll the changes back.

Image Removed

 

 

Excerpt

Total compare from data to schema with IDERA SQL Comparison Toolset. Learn more > >

 

...

schema.

Image Added


Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/it-database-management-tools
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

Save

Save