Options

Can Packager use migration scripts from SQL Source Control?

AdamYAdamY Posts: 55 Bronze 3
edited February 5, 2013 5:34PM in SQL Packager Previous Versions
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?
· Share on Twitter

Comments

  • Options
    David AtkinsonDavid Atkinson Posts: 1,439 Rose Gold 2
    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
    Product Manager
    Redgate Software
    · Share on Twitter
Sign In or Register to comment.