Deploying Static Data With SQL Compare Command Line

Xaphan

I'm using SQL Compare in my CI process to deploy databases to my test server. The CI server calls the SQL Compare command line in order to do this. Compare deploys the database schema just fine, but will not deploy any static data.

First, the CI server gets the automated database scripts from source control and places it on the build server. It then calls SQL compare command line and sets the source as the folder with the scripts and the source as the test database server. I have confirmed that the scripts folder contains a /data folder that holds the static data.

Is there an option that I need to set in the command line in order to do this? Should this this actually done using SQL Data Compare?

ov_dev

With the latest verion of SQL Compare you just specify /Include:StaticData in the command line and it'll do waht you want.

Xaphan

This is exactly what I needed. Thanks!