Red Gate forums :: View topic - Deploying Static Data With SQL Compare Command Line
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Deploying Static Data With SQL Compare Command Line

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Xaphan



Joined: 20 Apr 2012
Posts: 12

PostPosted: Tue Apr 16, 2013 1:33 am    Post subject: Deploying Static Data With SQL Compare Command Line Reply with quote

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?
Back to top
View user's profile Send private message
ov_dev



Joined: 20 Sep 2012
Posts: 4

PostPosted: Tue Apr 16, 2013 9:38 am    Post subject: Reply with quote

With the latest verion of SQL Compare you just specify /Include:StaticData in the command line and it'll do waht you want.
Back to top
View user's profile Send private message
Xaphan



Joined: 20 Apr 2012
Posts: 12

PostPosted: Tue Apr 16, 2013 9:04 pm    Post subject: Reply with quote

This is exactly what I needed. Thanks!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group