from $395
($494 including support & upgrades)
-
- Purchase this now
-
-
SQL Compare®
Walk-through 3: Working with script files and backups
This walk-through will show you:
- How to export a data source
- How to compare and synchronize with script files
- How to deploy a database from scripts
Stop walk-through
Step 1: Exporting a data source (1)
SQL Compare enables you to save a database schema as a set of script files. A separate creation script file is generated for each object in the database schema, and stored within a single folder. You can compare the collection of script files with a live database, a SQL Compare snapshot, or with another scripts folder.
You can use script files:
- for version control of databases; for example, you may want to store the script files in a source control application, in which you can track the modified or new objects, and then deploy the scripts against another schema
- to compare databases on unconnected SQL Servers
- to compare your own object creation scripts with a live database
- to deploy a database by synchronizing a set of scripts against an empty database
To save a database as a set of script files, at the bottom of the Comparison Projects screen click on the Export a Data Source button.