Data Compare performance
wonderbison
Posts: 18 Bronze 1
Hi
I am trying to use Data Compare to compare 2,400 tables between 2 databases. About half the tables have no PK because they are used as bulk load. I am therefore having to set comparison keys myself.
1. Could you have an option to "auto add" a comparison key of all comparable columns (which is what I am doing manually
2. More important, after every table where I have checked said columns the Tables & Views tab/screen takes a VERY long time to refresh. So that's a lot of time wasted for my 1,000+ columns I am waiting on the tool refreshing (for an unknown reason). I have "Always include newly added tables" unchecked, so its not that. Could you look to improve the performance in this area please?
This is a one off but might help others
Thanks
Robin
I am trying to use Data Compare to compare 2,400 tables between 2 databases. About half the tables have no PK because they are used as bulk load. I am therefore having to set comparison keys myself.
1. Could you have an option to "auto add" a comparison key of all comparable columns (which is what I am doing manually
2. More important, after every table where I have checked said columns the Tables & Views tab/screen takes a VERY long time to refresh. So that's a lot of time wasted for my 1,000+ columns I am waiting on the tool refreshing (for an unknown reason). I have "Always include newly added tables" unchecked, so its not that. Could you look to improve the performance in this area please?
This is a one off but might help others
Thanks
Robin
Tagged:
Answers
Thanks for your post and apologies for the delay in reply.
This was given to product development and analysed but it was concluded that it will not be worked on in the near future so we wanted to let you know that.
Kind regards
Richard Lynch.
Redgate Software