Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 How To Migrate Triggers and Packages Using SSMA

Author  Topic 

vijeshmohan
Starting Member

1 Post

Posted - 2008-05-11 : 12:55:45
I am using ssma to migrate database 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 and triggers? 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.
what could be the problem?

thanks

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-11 : 15:58:39
You may need to do that manually since lot of statement syntax are different between sql server and Oracle.
Go to Top of Page
   

- Advertisement -