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.

Error when linking a database to Subversion

Postby mvargas » Mon Aug 08, 2011 3: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

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

Postby mvargas » Tue Aug 09, 2011 4: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.
Posts: 2
Joined: Mon Aug 08, 2011 3:28 pm

Postby james.billings » Wed Aug 10, 2011 4: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!
Posts: 1122
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests