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, data type, 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 click Stored Procedure Properties in a physical model.

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

   The Stored Procedure Editor opens.

2. Select the stored procedure in the Navigation Grid that you want to migrate.
3. Click the Code tab and modify the SQL stored procedure in the Code text area to reflect the SQL syntax for your target server.
4. Click Close.

   Your changes are saved and the Stored Procedure Editor closes.

More information:

Define the Stored Procedures SQL Code