xSQL Object & xSQL Data Compare

Scripting

 

Both xSQL Object and xSQL Data Compare provide extensive scripting capability. You can script individual objects or you can script whole databases. The scripting functionality is available only from the context menu of the SQL Servers panel (the object tree on the left).

Scripting schema and data together: by scripting schema and data together you have a complete script that both creates the database and populates it. This allows you to migrate a database as is from one environment to another without having to back it up first, create it on the destination server and then restore it.

When generating the script for the entire database the objects will be, by default, ordered based on their dependencies. This ensures that the script will execute successfully.

A range of scripting options allow you to customize the way the script is generated.