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
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 8:24 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
- 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