It is possible to use the schema model to deploy database schema changes to a database using SQL Compare, either via the SQL Compare user interface or via the SQL Compare Command Line.

Note that when deploying from a local server instead of a build server, the changes that will be deployed will be those in the local schema-model folder, which may be different from the changes committed to version control.

Deploying using the SQL Compare UI

To deploy using the UI, select Scripts Folder for the source and specify the schema-model folder under the Redgate Change Control project folder. The schema-model folder should contain a RedGateDatabaseInfo.xml file alongside a series of folders containing SQL scripts for your database objects.

Deploying using the SQL Compare command line

For full details about the SQL Compare command line, see the dedicated documentation.

The example below specifies the command for updating a database from a scripts folder (here the schema-model folder under the Redgate Change Control project folder), using the Redgate Change Control default comparison options.

sqlcompare /Scripts1:<enter folder> /Database2:<enter database connection string> /Synchronize /Options:Default,NoSQLPlumbing,IgnoreTSQLT,ConsiderNextFilegroupInPartitionSchemes,IgnoreUsers,IgnoreCollations,IgnoreDataCompression,IgnoreReplicationTriggers,IgnoreStatistics,IgnoreNotForReplication,IgnoreWithNocheck,DoNotOutputCommentHeader