Red Gate forums :: View topic - Can Packager use migration scripts from SQL Source Control?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager 6
SQL Packager 6 forum

Can Packager use migration scripts from SQL Source Control?

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
AdamY



Joined: 15 Oct 2010
Posts: 41

PostPosted: Tue Feb 05, 2013 11:07 pm    Post subject: Can Packager use migration scripts from SQL Source Control? Reply with quote

I have created my first migration script in SQL Source Control because I am splitting a table into 2 and don't want to lose data. Using Packager to generate a change script is nice because it will compare schema and data at the same time. However, I can't find a way for it to incorporate the SQL Source Control migration scripts like SQL Compare does. Can it be done in Packager?
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1124
Location: Twitter: @dtabase

PostPosted: Tue Feb 05, 2013 11:34 pm    Post subject: Reply with quote

No, it can't. Sorry.

However, the sqlcompare.exe command line can do this from a scripts folder source, so it would be worth trying this. We'd like to eventually allow SQL Compare Pro to include static data in the deployment script, if this is what you're hoping for.

the switch you need is /include:staticdata

More detail on the command line can be found here:
http://www.red-gate.com/supportcenter/Content/SQL_Compare/help/10.2/sc_cl_Switches_in_the_cl

David Atkinson
Red Gate
Back to top
View user's profile Send private message Send e-mail
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