Red Gate forums :: View topic - Presales Question
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Schema Compare for Oracle
Schema Compare for Oracle forum

Presales Question

Search in Schema Compare for Oracle forum
Post new topic   Reply to topic
Jump to:  
Author Message
greddin



Joined: 15 Apr 2011
Posts: 1

PostPosted: Fri Apr 15, 2011 2:18 pm    Post subject: Presales Question Reply with quote

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.
Back to top
View user's profile Send private message
Tom Harris



Joined: 06 Oct 2004
Posts: 308

PostPosted: Thu Apr 21, 2011 11:05 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group