How can we help you today? How can we help you today?

Generate migration scripts on command line

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
0

Comments

2 comments

Sort by
  • James B
    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 B
    0
  • toeairina
    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
    0

Add comment

Please sign in to leave a comment.