Red Gate forums :: View topic - Registering databases
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare Previous Versions
SQL Data Compare Previous Versions forum

Registering databases

Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
keejh



Joined: 04 Jul 2011
Posts: 2

PostPosted: Mon Jul 04, 2011 9:16 am    Post subject: Registering databases Reply with quote

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
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Tue Jul 05, 2011 5:10 pm    Post subject: Reply with quote

Thanks for your post.

Have you tried using the project option 'use case sensitive object definition'?
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
keejh



Joined: 04 Jul 2011
Posts: 2

PostPosted: Wed Jul 06, 2011 4:34 am    Post subject: Reply with quote

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'
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Fri Jul 08, 2011 4:27 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
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