Red Gate forums :: View topic - Get Latest not working after initial linking to SVN database
Return to www.red-gate.com RSS Feed Available

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

Get Latest not working after initial linking to SVN database

Search in SQL Source Control 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Ausarb



Joined: 13 Sep 2011
Posts: 4

PostPosted: Tue Sep 13, 2011 6:53 pm    Post subject: Get Latest not working after initial linking to SVN database Reply with quote

After linking to a newly created DB to SVN, the Get Latest tab isn't working as expected.

I created a DB and committed it to SVN just fine on my old Windows XP image. I then got a new Windows 7 image, create a new DB, link it to one in SVN that I created while on XP. Everything looks like it worked correctly. It does link the database, but when I click the Get Latest tab (or right click on the DB and say to do a get latest) it tells me that I'm current but I've got no tables or SP in my database.

Going to the "Commit Changes" tab shows all of the missing tables and SP's as pending drops. I can select all of them and do an "undo" and that action creates the tables but this obviously isn't the intended way to pull down a DB from SVN and that way doesn't work for getting linked static data. Did I miss something?!? It is a shared DB BTW....

I was following the instructions here.

SQL Source Control 2.2.1.23
SSMS 10.0.4064.0
Windows 7 SP1 64-bit
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1124
Location: Twitter: @dtabase

PostPosted: Wed Sep 14, 2011 12:37 am    Post subject: Reply with quote

As you've chosen 'shared database', it is not expecting that more than one database will be linked to the same repository in source control, hence the unexpected behavior.

If you're looking to deploy a new database based on what's in source control, the supported method is to use SQL Compare to achieve this.

If you hope to develop on multiple databases pointing to the same source control location, you should consider selecting the 'dedicated' model for this.

Do let us know if you need further assistance,

David Atkinson
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
Ausarb



Joined: 13 Sep 2011
Posts: 4

PostPosted: Wed Sep 14, 2011 3:56 pm    Post subject: Reply with quote

Makes sense, thanks! I suppose that if your "shared" DB server ever bit the dust in order to restore it from SVN, you would create a new DB, link it as dedicated, pull down everything and then relink it as shared.
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