Competition: What’s your favorite Redgate tool? Enter now.

Get changes for database to put inot Source Control

lnrobbylnrobby Posts: 2 New member
edited June 29, 2016 12:58PM in SQL Source Control
Hi
I am a new user so just trying it out.

I have an original database backup and have made a few changes to that database prior to getting SQL Source Control

How can I "baseline" the original database into SC and then generate the changes I have made by restoring the latest version?

Thanks

Len

Comments

  • Sergio RSergio R Posts: 595 Rose Gold 5
    Hi Len,

    If you have a backup of both the original state and the current state and want to keep both in Source Control, you could:

    1- Restore original state
    2- Link DB to Source Control
    3- Commit original state to Source Control
    4- Restore current state
    5- Commit current state to Source Control

    Your Version Control System should now contain both versions of the DB

    Thank you,
    Sergio
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
Sign In or Register to comment.