How does handling of duplicate rows behave
vanram
Posts: 64
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.
Comments
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
do i have to enumerate some of these situations?
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com