Can Packager use migration scripts from SQL Source Control?

[AdamY]

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?

[David Atkinson]

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