Generate migration scripts on command line

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

Generate migration scripts on command line

Postby toeairina » Wed Apr 10, 2013 10:42 am

Hi!
I have one SQL Sever database using RedGate SQL Source Control.
And i want to generate migration scripts between 2 versions in source control using command line for the same database.

Can anyone help me about this issue?
Thanks
toeairina
 
Posts: 2
Joined: Tue Apr 09, 2013 3:24 pm

Postby james.billings » Fri Apr 12, 2013 1:08 pm

Migration scripts can only be generated through the SQL Source Control interface unfortunately, and not at the command-line.

Feel free to request this ability on our Uservoice though, and we can see how many other users would like to see it as an option.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Postby toeairina » Fri Apr 12, 2013 1:38 pm

Thanks for your response.
I found a solutions that helps me:

sqlcompare /Sourcecontrol1 /versionusername1:username /versionpassword1:passwd /revision1:100 /scriptsfolde
rxml:C:\\SourceControlLocation.xml /SourceControl2 /versi
onusername2:username /versionpassword2:passwd /revision2:90 /scriptFile:C:\\Scripts\\WidgetSyncScrip.sql
toeairina
 
Posts: 2
Joined: Tue Apr 09, 2013 3:24 pm


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 0 guests