How can we help you today? How can we help you today?
halla01
Activity overview Badges (0) Posts (0) Comments (1)

Activity overview

Latest activity by halla01

ids said: I am trialing SQL Data Compare to solve the issue of copying / syncing data from a production database to a training environment. I don't want to copy all the data but instead a selected snapshot - the last weeks data. The main table I want to copy has a date on it so I can easily filter the rows I want from that using a WHERE clause. However linked to the main table is a number of other tables that I can't use the same restriction on. Is there anyway to have the data synchronization copy a row from a table and then all dependent rows from related tables? It sounds like you're on the right track with SQL Data Compare for your data synchronization needs. To achieve your goal of copying a specific snapshot of data along with its dependent rows, consider these steps: Identify Dependencies: Start by mapping out the relationships between your main table and the dependent tables. This will help you understand which rows you need to copy. Use SQL Scripts: Instead of relying solely on SQL Data Compare, you might create a custom SQL script that: Copies the rows from your main table that match your date filter using a SELECT statement with a WHERE clause. For each copied row, retrieves and copies the dependent rows from the linked tables. You can use JOIN statements to get these rows based on foreign key relationships. Transaction Management: Ensure that your operations are wrapped in a transaction to maintain data integrity. This way, if any part of the process fails, you can roll back all changes. Testing: Before executing in the production environment, thoroughly test your script in a development or test environment to ensure it works as expected. By combining SQL Data Compare with custom SQL scripting, you should be able to selectively copy your desired data along with its dependencies. [image] / comments
  1. Community
  2. SQL Data Compare 11
  3. Syncing table and related data
ids said: I am trialing SQL Data Compare to solve the issue of copying / syncing data from a production database to a training environment. I don't want to copy all the data but instead a sel...
0 votes
Total activity
2
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1