May 11, 2008 at 4:04 am
I am using ssma to migrate db from oracle 9i to sql server 2000. I successfully migrated oracle tables,views,procedures,functions etc.. But can you please help me on how to migrate packages,triggers and indexes? Here i can able to view the headings like"Triggers", "packages", "Indexes" in SSMA. But none of my oracle objects are displaying under these headings.
please help me whether this is possible to do in ssma?
if so how?
Thanks.
May 11, 2008 at 4:29 am
Indexes definitions are not compatible between Oracle and SQL Server and must be extensively modified.
Packages are not supported by SQL Server.
Trigger are not compatible between Oracle and SQL Server and therefore, cannot be migrated but instead must rewritten. Oracle only supports row-level triggers and SQL Server only supports statement-level triggers.
SQL = Scarcely Qualifies as a Language
May 11, 2008 at 4:49 am
Thanks for the reply.
There are options available for triggers,packages and indexes in ssma But i don't know why it is not displaying oracle objects under the respective headings.
just now i read an article, it tells that ssma can convert all these objects also.. but i don't know how!!!(need ur help...)
it has been mentioned like packaged functions & procedures will be converted to individual functons and procedures...
I think only "before trigger" is not in sql server and all others(after and instead of) are same..
Thanks for the infiormation regarding sql server, but in oracle we can create both statement and row level triggers.
May 11, 2008 at 5:42 am
In microsoft site itself it has been mentioned that we can do package and trigger migration with SSMA.
please help me if you have any idea on this.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply