Sybase TO Oracle Migration : Few Intresting Questions
888369Sep 15 2011 — edited Sep 20 2011Hi All,
I have been able to migrate sybase ASE 11 to Oracle 11g sucessffully without a much difficulties; thanks to SQL Developer.
However,
I noticed couple of intresting things and would like to know more on them.
1. I did it using Online mode so while the data move operation is being done the triggers migrated do not fire, is that correct ?
2. Except triggers not being fired and running scripts manually, what else is the difference between Online and offline mode and which is recommended and why?
3. While online data move is being performed on a Prod database, and somebody modifies a few rows in source database, are they taken care of to be migrated too ?
4. Does the SQL developer follow best practices while creating Indexes on tables?
5. I saw the trigger that got created to manage sequences for each Identity column from sybase which is an Insert Or Update Trigger however, the trigger body is such that it gets executed only on Insert. than why is it made as an Update trigger too?
Would really appreciate any more pointers on these questions.
Thanks,
Manish Ramrakhiani