![]() ![]() I imagine this has something to do with the fact that the source and copy exist in different servers which use different SQL dialects and, presumably, structure data differently.Īssuming the above is all correct then that just leaves the last option which does indeed seem to be a possible solution. I tried using the Schema Compare/Migrate and the Data Compare functions but they seem to break whenever I try comparing the source table with its copy even though the copy is literally just an export of data from the source table. I imagine the second option would also not be possible due to the aforementioned. If this is possible however I would love to know how as this would be the easiest solution! As such I would not think it possible to write a simple query/script to query the max update time from SQL server, select columns from a table in the OpenEdge DB using that max update time, and then insert them into the aforementioned table in the SQL Server DB as these are two entirely separate servers and connections. ![]() We are migrating the data from Progress OpenEdge to Microsoft SQL Server. Additionally, the Progress OpenEdge connection is Read Only. One resides in a Progress OpenEdge Server and the other resides in a Microsoft SQL Server. The databases I am synchronizing data between reside in separate connections. That said I suppose I was not entirely clear in my original post so forgive me for that. To view and edit the data in a table, you need to right-click on the target table name and select View data.The content of the table will be displayed in the. Thank you very much for your response! This is exceptionally helpful!įunnily enough the first solution you proposed would be ideal. I'd recommend testing some approaches to see what works best for your use case. The best option depends on how often you need to sync, the amount of data, and the performance needed. ![]() Export the source data to a CSV file, then use DBeaver's CSV import tool to load the data into the target table, choosing options to update existing rows based on a key column like an ID. Then, generate a synchronization script that only updates records in the target that are new or changed in the source. Use DBeaver's database compare tool to compare the structure and data between the source and target. Create a view in DBeaver that joins the two tables and filters only to return newer records, then use the view as the source for an INSERT statement into the target table. JOIN (SELECT MAX(last_updated) max_date FROM target_db.target_table) t ON s.last_updated > t.max_date INSERT INTO target_db.target_table (col1, col2. Use an INSERT statement with a JOIN and WHERE clause to only insert records from the source table with a newer last_updated timestamp than the maximum last_updated in the target table. Here are a few ways you could approach synchronizing data between two tables in different databases using conditional logic in DBeaver: ![]()
0 Comments
Leave a Reply. |