Can Packager use migration scripts from SQL Source Control?
AdamY
Posts: 55 Bronze 3
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?
Comments
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
Product Manager
Redgate Software