Red Gate forums :: View topic - Error trying to sync from command link
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  | Register 
Go to product support center
SQL Source Control 1
SQL Source Control 1 forum

Error trying to sync from command link

 Search in SQL Source Control 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
ciaranarcher



Joined: 24 Jun 2011
Posts: 21
PostPosted: Tue Jul 19, 2011 9:04 am    Post subject: Error trying to sync from command link Reply with quote
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:
sqlcompare /scripts1:"C:\prog\temp-svn\BR\trunk" /database2:BR /sync

Error:

Code:
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
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 840
Location: My desk.
PostPosted: Wed Jul 20, 2011 4:25 pm    Post subject: Reply with quote
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.
Back to top
View user's profile Send private message
ciaranarcher



Joined: 24 Jun 2011
Posts: 21
PostPosted: Thu Jul 21, 2011 8:44 am    Post subject: Re: Reply with quote
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.
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