Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can I use the Migration Workbench to migrate only stored procedures?

April 26, 2017migrate migration procedures stored workbench

0

Posted

Can I use the Migration Workbench to migrate only stored procedures?

1 Answer

0

Posted

The Migration Workbench works first by capturing the source database. It loads the entire data dictionary of the source database into the Source Model and creates the Oracle Server equivalent called the Oracle Model. After the capture is complete, you can run the Migration Wizard. This forces you to create all users and their tables. After the users and tables are created, you can create the stored procedures. You should capture the entire database. You can then use the Migration Wizard to migrate only the stored procedures by doing the following: In step 2, choose Next to create the users and tables. If you are recreating the users and tables, choose Yes. In step 3, choose No to migrate the table data to an Oracle database. In step 4, move all the schema objects to the Available list except for Packages and Procedures.