Registering databases

Compares and synchronizes SQL database content.

Registering databases

Postby keejh » Mon Jul 04, 2011 9:16 am

Hi,

I have a bak file from production. I have restored the database to a sandbox from this bak file. I would like to compare the changes between the bak file and the database restored.

I am getting error during the registering databases process.
"A duplicate object name has been found. This may occur if the SQL Server that you are registering is case sensitive but the case sensitive options is not set"

Any idea how to resolve this?

Thanks,
Kenny
keejh
 
Posts: 2
Joined: Mon Jul 04, 2011 9:11 am

Postby Chris Auckland » Tue Jul 05, 2011 5:10 pm

Thanks for your post.

Have you tried using the project option 'use case sensitive object definition'?
Chris
Chris Auckland
 
Posts: 760
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Postby keejh » Wed Jul 06, 2011 4:34 am

Actually I am not using case sensitive on my database.

Now I am getting this error if I check the option 'use case sensitive object definition'.
Item has already been added. Key in dictionary: '1:0' Key being added: '1:0'
keejh
 
Posts: 2
Joined: Mon Jul 04, 2011 9:11 am

Postby Chris Auckland » Fri Jul 08, 2011 4:27 pm

Sorry for the delay.

Are you able to see if the error occurs when registering the backup or the database?

It would also be useful if you could send me the application logs. I've sent instructions in another email.
Chris
Chris Auckland
 
Posts: 760
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests