Red Gate forums :: View topic - How does handling of duplicate rows behave
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

How does handling of duplicate rows behave

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



Joined: 29 Nov 2005
Posts: 43

PostPosted: Wed Jan 25, 2012 5:37 pm    Post subject: How does handling of duplicate rows behave Reply with quote

I have data that for the best custom key i can define still results in duplicate rows. I want to know how Data compare will handle duplicates when maybe some of the rows match left to right but some do not. I have configured data compare to not show identical rows.
Back to top
View user's profile Send private message MSN Messenger
eddie davis



Joined: 14 Jun 2006
Posts: 922
Location: Red Gate Software

PostPosted: Wed Jan 25, 2012 9:32 pm    Post subject: Reply with quote

Thank you for your post into the forum.

As you most likely aware, SQL Data Compare requires some sort of comparison key to match rows of data. The application will automatically set a comparison key is your tables as a Primary Key or unique constraint.

As you have found if the product cannot find an automatic comparison key, you need to set a manual comparison key. You can configure multiple columns to make the comparison key if required, I helped a customer some time ago where very column in table needed to be selected to configure the comparison key.

The problem is if you have duplicate rows, you will see weird and unreliable results. I cannot accurately inform on what you will see in the results screen.

Also depending how the tables and constraints are created in the target database, you will most likely experience failure during the synchronization phase.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
vanram



Joined: 29 Nov 2005
Posts: 43

PostPosted: Thu Jan 26, 2012 12:55 am    Post subject: Reply with quote

I agree this situation is not desirable. But it is not allways possible to have unique rows, and i agree that the sync would be problematic. My situation i am using this to prove data equality, not for sync'ing. I believe it is definable as to how SQL Data compare will behave. I can if required provide some specific example, but these are standard, that are the same ones you would list if you had to enumerate the interesting scenarios that you would want to know the handling behaviour.
do i have to enumerate some of these situations?
Back to top
View user's profile Send private message MSN Messenger
eddie davis



Joined: 14 Jun 2006
Posts: 922
Location: Red Gate Software

PostPosted: Thu Feb 02, 2012 7:10 pm    Post subject: Reply with quote

Sorry for the delay in replying to you.

A support call has been created for you, the call reference number is F0056664.

Can you please send to us via e-mail, a copy of the table creation script from each data source. The columns you have selected to be the custom comparison key and screen shots of the behaviour you are seeing.

Hopefully we will be able to provide an answer to you. Please send the e-mail to support@red-gate.com and include the above call reference number in the subject field on the e-mail.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
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