Updating Scripts folder to SVN

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

Updating Scripts folder to SVN

Postby markv » Fri Nov 12, 2010 4:08 pm

Currently, we have always used SQL Compare to create a Scripts folder then SVN Commit'd that into the repository. The Source Control appears to use the same structures (albeit with more directories and an extra source control marker file) so surely can you link to an SVN location that already has a script generated folder?

It would appear that Source Control does not allow it. What is the reason behind this and can it recognise the Scripts folder and therefore "upgrade" it to source control format?
markv
 
Posts: 14
Joined: Tue Jul 06, 2010 4:47 pm

Postby David Atkinson » Sat Nov 13, 2010 12:21 am

Could you try creating a blank file called redgate.ssc and put it in the scripts folder.

SQL Source Control should now recognise this as a valid repository.

Let us know if this doesn't work.

David Atkinson
Red Gate Software
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby markv » Mon Nov 15, 2010 10:36 am

I had half through about doing this, though the Source Control generates more folders than the scripts did, so wasn't sure if that mattered? (Will be giving it a go shortly and let you know).
markv
 
Posts: 14
Joined: Tue Jul 06, 2010 4:47 pm

Postby David Atkinson » Tue Nov 16, 2010 8:23 am

Did that work out for you?
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby markv » Tue Nov 16, 2010 6:05 pm

That did indeed work though I made sure to keep the Case Sensitivity of the filename within SVN. Now, I just need to see whether the differences list are because I have changed things since the database was committed or whether the latest commit using SQL Compare is out of date.
markv
 
Posts: 14
Joined: Tue Jul 06, 2010 4:47 pm


Return to SQL Source Control 1

Who is online

Users browsing this forum: No registered users and 0 guests