Error when linking a database to Subversion

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

Error when linking a database to Subversion

Postby mvargas » Mon Aug 08, 2011 4:58 pm

I get the error: An item with the same key has already been added. I was linking my database using a Shared database Development Model as usual.

I removed the SVN folder and created a new one for this database. After linking to the new folder, tried commiting changes but error comes up.

Now I'm not able to link this database to my Source Control.

My installed version is 2.2.1.23

Any ideas on how to solve this issue?
mvargas
 
Posts: 2
Joined: Mon Aug 08, 2011 4:28 pm

Postby mvargas » Tue Aug 09, 2011 5:00 pm

I was able to fix my issue! By using SQL Compare I found a suspicious "duplicate" object, a table with a name starting with blank space like this [ table_name] and my regular table [table_name].
As soon as I removed the one starting with blank space I tried linking the database to Source Control and then committed my changes successfully. Again I'm using Subversion and probably the file name for my table object was really duplicated at the folder level.
mvargas
 
Posts: 2
Joined: Mon Aug 08, 2011 4:28 pm

Postby james.billings » Wed Aug 10, 2011 5:11 pm

Thanks for posting back here with your findings - a couple of other customers have reported similar errors directly to us recently, so it gives us another thing to check over with them!
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Source Control 2

Who is online

Users browsing this forum: No registered users and 0 guests