Red Gate forums :: View topic - Unlink/Link and retain history?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 1
SQL Source Control 1 forum

Unlink/Link and retain history?

Search in SQL Source Control 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
douglashwilliams



Joined: 09 Aug 2010
Posts: 2

PostPosted: Mon Aug 09, 2010 6:56 pm    Post subject: Unlink/Link and retain history? Reply with quote

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
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 308
Location: Cambridge, UK

PostPosted: Tue Aug 10, 2010 7:22 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
douglashwilliams



Joined: 09 Aug 2010
Posts: 2

PostPosted: Tue Aug 10, 2010 7:27 pm    Post subject: Re: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group