Can Packager use migration scripts from SQL Source Control?

Forum for users of SQL Packager database archive utility

Can Packager use migration scripts from SQL Source Control?

Postby AdamY » Tue Feb 05, 2013 10: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?
Posts: 41
Joined: Fri Oct 15, 2010 7:24 pm

Postby David Atkinson » Tue Feb 05, 2013 10: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: ... _in_the_cl

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

Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: Yahoo [Bot] and 0 guests