Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sybase TO Oracle Migration : Few Intresting Questions

888369Sep 15 2011 — edited Sep 20 2011
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 18 2011
Added on Sep 15 2011
2 comments
166 views