Options

Generate migration scripts on command line

toeairinatoeairina Posts: 3
edited April 12, 2013 8:38AM in SQL Source Control Previous Versions
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
· Share on Twitter

Comments

  • Options
    James BJames B Posts: 1,124 Silver 4
    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.
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
  • Options
    toeairinatoeairina Posts: 3
    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
    · Share on Twitter
Sign In or Register to comment.