Presales Question

Compares and synchronizes the schemas of Oracle databases

Presales Question

Postby greddin » Fri Apr 15, 2011 1:18 pm

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?

Thank you.
Posts: 1
Joined: Fri Apr 15, 2011 1:14 pm

Postby Tom Harris » Thu Apr 21, 2011 10:05 am

Hi there,

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

Regards, Tom

Tom Harris, Red Gate Software
Tom Harris
Posts: 308
Joined: Wed Oct 06, 2004 2:45 pm

Return to Schema Compare for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests