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.
StoredProcedures - Meta Data Creation
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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