question

jacobmat9 avatar image
jacobmat9 asked

moving stored procedure for scheduling

we have a NETEZZA production box where a stored procedure has been created. How can i move the stored procedure to SQL 2008R2 for scheduling it. which is easier, creating an ETL package or creating a stored procedure in SQL 2008 R2 using the query from the Stored Proc which is in netezza and schedule it ?
schedulingnetezza
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Grant Fritchey avatar image
Grant Fritchey answered
I don't know neteeza, but you'll need to export the stored procedure to text and then see if the query within that stored procedure can be simply converted straight to T-SQL or if you'll have to rewrite it. But after you export from Neteeza, you just have to write a CREATE PROCEDURE statement within SQL Server.
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks Grant. I will try that.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.