Compares and synchronizes the schemas of Oracle databases
Moderators: eddie davis, richardjm, Michael Christofides, neil.anderson
I have two databases. Database #1 has an older schema but contains all the data. Database #2 has a newer schema but doesn't contain any data. Is it possible to synchronize the schemas between the two so that data isn't lost? Ultimately Database #1 getting the Database #2 schema without loss of data?
- Posts: 1
- Joined: Fri Apr 15, 2011 2:14 pm
many thanks for your question. Schema Compare for Oracle is designed to make schema changes without any loss of data. Where possible we use ALTER statements to change table definitions. However, there are certain changes that are not possible with an alter statement. In that case we copy the table data into a temporary structure, before the table is dropped and re-created. The original data is then copied back into place.
There are circumstance where data can be truncated e.g. the 'width' of a column is reduced. In this case we provide explicit warnings in the tool that this happening.
My advice would be to try out Schema Compare for Oracle for yourself, but always make sure you've taken a backup of the target database before you make any changes
Tom Harris, Red Gate Software
- Posts: 308
- Joined: Wed Oct 06, 2004 3:45 pm
Return to Schema Compare for Oracle
Who is online
Users browsing this forum: No registered users and 0 guests