Can Packager use migration scripts from SQL Source Control?

Packages and compresses schema and contents of SQL Server databases

Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings, Marianne

Can Packager use migration scripts from SQL Source Control?

Postby AdamY » Tue Feb 05, 2013 11:07 pm

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?
AdamY
 
Posts: 41
Joined: Fri Oct 15, 2010 8:24 pm

Postby David Atkinson » Tue Feb 05, 2013 11:34 pm

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/C ... _in_the_cl

David Atkinson
Red Gate
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests