Red Gate forums :: View topic - Linking DB to SC for first time , how SC depo affected?
Return to www.red-gate.com RSS Feed Available

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

Linking DB to SC for first time , how SC depo affected?

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
mario17



Joined: 15 Jan 2014
Posts: 9
Location: United States

PostPosted: Thu Apr 03, 2014 5:51 pm    Post subject: Linking DB to SC for first time , how SC depo affected? Reply with quote

Hi,

I had broken metadata on this db, so I unlink my db and now trying to link it back, but not sure if it will be safe, will this clean all metadata from prev sc ??

On setup page I see that Linking db will <Link the database and Commit the objects>.
Does it mean that If I don't have let say usp_AlphaBravo in my BAK copy this copy will be deleted from SC depo when I do Linking? This sound scary for me....



Tx
mario
Back to top
View user's profile Send private message AIM Address
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Mon Apr 07, 2014 12:29 pm    Post subject: Reply with quote

Just linking won't change anything.
The DB or the repository will only be altered if you run through the process on the Get Latest or the Commit tab.
Back to top
View user's profile Send private message
zacuke



Joined: 15 Jan 2013
Posts: 3

PostPosted: Tue May 20, 2014 4:29 pm    Post subject: Re: Reply with quote

james.billings wrote:
Just linking won't change anything.


We have a server-side TFS plugin that ensures commit comments conform to a standard.

The plugin is blocking linking so in our experiencing just linking does something to the database because it is hitting the plugin.

I'm trying to find a work around in the plugin, but is Red-gate 100% sure that "just linking" doesn't try to commit anything whatsoever?

SQL Source Control is not giving us an option to type in a comment, therefore the comment of whatever action it is trying to perform when linking is not conforming to our standard.

Edit: It does commit when linking for the very first time, and SQL Source Control adds an #ignorepolicies into the commit comment so I was able to hard code an exception!
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Wed May 21, 2014 12:36 pm    Post subject: Reply with quote

Yes, we put in the basic folder structure and the RedGate.ssc file when you first link- so the #ignorepolicies is needed for that to succeed. From then on you need to either add a comment or the above #ignore command
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