SQL Source Control - 1.1

SQL Source Control

Learning SQL Source Control - 1.1

Deploying a database from source control

You can use SQL Source Control and SQL Compare to deploy a database from source control to a server.

The SQL Source Control scripts folders share the format used by SQL Compare and SQL Data Compare, so deployment is relatively simple.

The process is simplified by using SQL Server Management Studio Integration Pack which adds schema and data deployment options to the right-click menu in the Object Explorer.

Deploying with SQL Server Management Studio Integration Pack

To deploy a database schema, in the Object Explorer, right-click a database, click Schema Compare/Deploy, and click Set as Source

The SQL Server Management Studio Integration Pack Schema Compare/Deploy tab is displayed:

You can deploy the current database version or specify a version from source control.

You can deploy to a target database, create a new database, or create a change script to update a target source control version.

For more information, see SQL Server Management Studio Integration Pack

Deploying without SQL Server Management Studio Integration Pack

To deploy a database:

  1. Create a local copy of the scripts folder
  2. Migrate the local copy to the target server using SQL Compare

Optionally, you can also deploy any relevant static data using SQL Data Compare.

In this example the database WidgetDev is already in source control.

This example uses the SQL Compare and Subversion command line interfaces.

It is also possible to deploy the database using the SQL Compare graphical user interface, and a source control client such as TortoiseSVN

1) Create a local copy of the database

At a command prompt, type:

cd C:\program files\subversion\bin

svn update http://svn-eval.red-gate.com/svn/<project>/trunk/WidgetDev "C:\WidgetDevScripts"

Where:

  • http://svn-eval.red-gate.com/svn/<project>/trunk/WidgetDev is the URL for the database in your Subversion repository
  • "C:\WidgetDevScripts" is the file path for the directory where the local copy will be created

A local copy of the scripts folder is created. This is a Subversion working copy, and is associated with the Subversion repository.

2) Migrate the local copy to the target server

At a command prompt, type:

cd C:\program files\red gate\SQL Compare 8

     /sqlcompare /scr1:"C:\WidgetDevScripts"

     /S2:WidgetServer /U2:<username> /P2:<password>

     /db2:"WidgetTest"

     /sync

Where:

  • /scr1:"C:\WidgetDevScripts" specifies the local copy, WidgetDevScripts, as the source for a SQL Compare synchronization
  • /S2:WidgetServer /U2:<username> /P2:<password> specify the server, user name, and password you are using
  • /db2:WidgetTest specifies WidgetTest as the target of a SQL Compare synchronization
  • /sync performs the SQL Compare synchronization, making schema of WidgetTest the same as the schema in WidgetDevScripts

The database is updated. Its schema is now the same as the version you checked out of source control.

For more information, see Simple examples using the SQL Compare command line

See also

Linking a database to source control

Committing changes

Getting the latest version

Using SVN bug IDs & TFS work items

Viewing source control logs / history

Getting a specific version

Undoing changes

Conflicts

Was this article helpful?

Search support
Forums
Visit the SQL Source Control forum.
Learning SQL Source Control
Knowledge base

SQL Source Control

all SQL products

all products

Notes & articles

SQL Source Control

all SQL products

all products

Demos & walkthroughs

SQL Source Control