DSXchange

Hi All,

How to Import Stored Procedures of SQL Server 7.0/2000 using DataStage Manager(Meta Data).

I wanna to Copy Stored Procedures from one SQL SERVER DB Schema to another SQL SERVER DB Schema


Thanks In advance,
K.S.Rajan.

You can import the column definitions from a stored procedure into DataStage using the Manager client (or the Designer client if your version of DataStage is 5.0 or later).
This does NOT import the definition of the stored procedure. Thus there is no mechanism for exporting a stored procedure from DataStage to SQL Server.
However, all you need to do is to use any of the SQL Server clients, display the definition of the stored procedure from one schema and paste it into the other schema.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518