Physical Modeling › Stored Procedures › Migrate a Stored Procedure

Migrate a Stored Procedure

Macros in the stored procedure are replaced with the appropriate object names and characteristics (for example, datatype, keys, domain, and default information) for the selected target server. When you change the target server for a model, you often do not need to alter the macros to generate the correct information for the new server, just the SQL code.

To migrate a stored procedure

1. Right-click a table or a view and select Stored Procedures in a physical model.

   Note: In Oracle, you can right-click a materialized view, and select Stored Procedures.

   The Stored Procedures dialog opens.

2. Select the stored procedure that you want to migrate from the Attached Stored Procedures list on the Code tab and modify the SQL stored procedure in the Code box to reflect the SQL syntax for your target server. Click OK.

   Your changes are saved and the dialog closes.

More information:

Define the Stored Procedures SQL Code

DBMS Migration Example