Unlink/Link and retain history?

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

Unlink/Link and retain history?

Postby douglashwilliams » Mon Aug 09, 2010 6:56 pm

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
douglashwilliams
 
Posts: 2
Joined: Mon Aug 09, 2010 6:52 pm

Postby chriskelly » Tue Aug 10, 2010 7:22 pm

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.
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Re:

Postby douglashwilliams » Tue Aug 10, 2010 7:27 pm

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.
douglashwilliams
 
Posts: 2
Joined: Mon Aug 09, 2010 6:52 pm


Return to SQL Source Control 1

Who is online

Users browsing this forum: No registered users and 0 guests