Deploying data changes where there are dependencies
aboo62
Posts: 7
Hi,
I am in the middle of trialling the products in the toolbelt and am trying out SQL Compare and SQL data compare.
Love the SQL compare tool. Really helped me see differences between a production databse and a QA one. Now I'm trying to determine the data in one database comparing to one which is a bit older (i.e want to bring it up to date in a data perspective)
I am having trouble running the deploy because of tables which depend on others. Does this tool figure out which ones it should apply first. Eg Orders and Order items. Orders hould be synced first then order items, but because of alphabetics, OrderItems is attempted first then Orders. It really needs to determine which tables are at the bottom of the heirarchy and do those first and then traverse up the tree applying data updates along the way. I'm manually deploying 1 table at a time after determining which ones I can safely do first, then second and so on. (I used the dpendency tracker to help me work out the tree)
This could be a problem with 100's of tables.
Id there some setting I shuld use to make it work out the order in which it should apply the data updates and inserts etc.
Annabel
I am in the middle of trialling the products in the toolbelt and am trying out SQL Compare and SQL data compare.
Love the SQL compare tool. Really helped me see differences between a production databse and a QA one. Now I'm trying to determine the data in one database comparing to one which is a bit older (i.e want to bring it up to date in a data perspective)
I am having trouble running the deploy because of tables which depend on others. Does this tool figure out which ones it should apply first. Eg Orders and Order items. Orders hould be synced first then order items, but because of alphabetics, OrderItems is attempted first then Orders. It really needs to determine which tables are at the bottom of the heirarchy and do those first and then traverse up the tree applying data updates along the way. I'm manually deploying 1 table at a time after determining which ones I can safely do first, then second and so on. (I used the dpendency tracker to help me work out the tree)
This could be a problem with 100's of tables.
Id there some setting I shuld use to make it work out the order in which it should apply the data updates and inserts etc.
Annabel
Comments
This should normally be fine for SQL Data Compare. Could you enable logging (as per these instructions in our documentation), recreate the problem and then email the logfile to support@red-gate.com ?
You'll find the logfile in the %localappdata%Red GateLogsSQL Data Compare folder. If you put #32584 in the subject line of your email, I'll be able to find it easily.
Thanks.
Redgate Software