convert Oracle stored procedures to SQL Server

Question

Hi All,

I am converting Oracle stored procedures into SQL server 2008. However The source tables will still be in Oracle database.

Earlier stored procedures were in oracle and were executed using batch jobs.

Now I have converted few procedures into T-SQL. But these procedures will still access tables that are stored in oracle.

How will I execute and schedule the procedures in SQL Server 2008.

Need suggestions.

Thanks,

Nitin Pawar

Answer 1

Use jobs executed by the SQL Server Agent. Start here How to: Schedule a Job (SQL Server Management Studio) http://msdn.microsoft.com/en-us/library/ms191439.aspx The SQL Server Agent is included in all editions of SQL Server except SQL Server Express.

---

Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

Answer 2

SQL Server Agent would be the way to schedule running those procedures. To run a T-SQL stored procedure against an Oracle database, you will need to define a Linked Server to that Oracle database: http://msdn.microsoft.com/en-us/library/ms188279.aspx