Issue on comparing 1 View

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Issue on comparing 1 View

Postby dcalliances » Fri Feb 03, 2012 4:31 am

Hi there

This is a bit odd actually. I've been using this piece of tools to compare the SQL and I have 1 issue which for unknown reason I have 1 VIEW that always have:

"1 object that exists in both but is different"

I've dropted the original and putting back in and sync. It's always the same thing.

Any ideas?

Thanks
dcalliances
 
Posts: 2
Joined: Fri Feb 03, 2012 4:26 am

Postby dcalliances » Fri Feb 03, 2012 4:40 am

Never mind.

We've solved this. It's bit odd actually. We've just go back to the original script and edit the VIEW object a bit and save it. Then run compare and take the script and apply and it works!!!
dcalliances
 
Posts: 2
Joined: Fri Feb 03, 2012 4:26 am

Postby andy.campbell.smith » Mon Feb 06, 2012 2:32 pm

Glad that you found a resolution to your problem, and thanks for the feedback! Let us know if you ever run into anything else and we'll be happy to help out.
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest