December 5, 2010 at 6:54 am
Please help me...Is it possible to run PL/SQL Procedures on Microsoft SQL Server 2000.If not,what changes do i need to make it run on SQL Server 2000.
December 5, 2010 at 7:31 am
You may want to look at the SQL Server Migration Assistant document (pdf) at:
http://download.microsoft.com/.../SQLServer2000MigrationAssistant_Final.pdf
A TechNet search for the SQL Server Migration Assistant
http://technet.microsoft.com/en-us/default.aspx
This article on SSC will explain its installation and use.
http://www.sqlservercentral.com/articles/upgrading/microsoftsqlservermigrationassistant/2145/
December 5, 2010 at 3:05 pm
anitha.chacko (12/5/2010)
Please help me...Is it possible to run PL/SQL Procedures on Microsoft SQL Server 2000.If not,what changes do i need to make it run on SQL Server 2000.
"It depends". 😀
IF the PL/SQL code was written in 100% ANSI compliant SQL, and if SQL Server 2000 has implemented all of the same ANSI code that you're trying to use, then yes it will probably run.
It's not likely that you will both of those conditions - each of the products have different levels of the ANSI SQL completed on their systems.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply