Options

Unlink/Link and retain history?

douglashwilliamsdouglashwilliams Posts: 3
edited August 10, 2010 2:27PM in SQL Source Control Previous Versions
Hi all -

I would like to unlink a database (it is now a production db) and create a link to a new dev/test db version. Can I do this and retain the history of changes for each table, sproc, function, etc?

Thank you
· Share on Twitter

Comments

  • Options
    chriskellychriskelly Posts: 378
    Thank you for your post.

    All the history, Stored Procedures etc should be fine for the new link.

    I would recommend creating the new link before removing the old one, just to be sure that everything goes ok. But if this is not an option, or undesireable, then ensure that you make a note of the Repository URL before removing the existing link.
    · Share on Twitter
  • Options
    douglashwilliamsdouglashwilliams Posts: 3
    chrisk5 wrote:
    Thank you for your post.

    All the history, Stored Procedures etc should be fine for the new link.

    I would recommend creating the new link before removing the old one, just to be sure that everything goes ok. But if this is not an option, or undesireable, then ensure that you make a note of the Repository URL before removing the existing link.

    Hi - Yes, that is what I ended up doing. I went ahead and set up the new/dev test db first, then pulled the plug. So far, so good.

    Thanks.
    · Share on Twitter
Sign In or Register to comment.