Error trying to sync from command link

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 trying to sync from command link

Postby ciaranarcher » Tue Jul 19, 2011 9:04 am

Hi there

I can link and sync a particular database just fine in SSC2, but when I try to do the same from the command line, I get an error:

Command:

Code: Select all
sqlcompare /scripts1:"C:\\prog\\temp-svn\\BR\\trunk" /database2:BR /sync

Error:

Code: Select all
Registering data sources
Error: A duplicate definition was found for the user xxxxxx. Ensure that case sensitivity options are set correctly and all object creation
scripts are valid. If the problem persists, contact our support.


I have tried unlinked and relinking the datasource to no avail. I have tried to look for duplicate files in the repo creating that user, but could not find a culprit.

Can someone please help?

Many thanks in advance.
Ciaran
ciaranarcher
 
Posts: 21
Joined: Fri Jun 24, 2011 9:52 am

Postby james.billings » Wed Jul 20, 2011 4:25 pm

Usually, that error would mean that it's finding duplicate definitions. A quick DOS command may help find possibles.... open up a command prompt, navigate to the folder (C:\\prog\\temp-svn\\BR\\trunk) then try the following:

findstr /S /C:"CREATE USER xxxxxxxx" *.*

Obviously replace the xxxxxxx with the username. See if that gives multiple matches.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Re:

Postby ciaranarcher » Thu Jul 21, 2011 8:44 am

Hi James

Yep, I got 2x matches ! It seems that dir was a little corrupted. Fixed up now.

Many thanks for your help!


james.billings wrote:Usually, that error would mean that it's finding duplicate definitions. A quick DOS command may help find possibles.... open up a command prompt, navigate to the folder (C:\\prog\\temp-svn\\BR\\trunk) then try the following:

findstr /S /C:"CREATE USER xxxxxxxx" *.*

Obviously replace the xxxxxxx with the username. See if that gives multiple matches.
ciaranarcher
 
Posts: 21
Joined: Fri Jun 24, 2011 9:52 am


Return to SQL Source Control 1

Who is online

Users browsing this forum: No registered users and 1 guest