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 ?
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.