Is it possible to run PL/SQL procedures on Microsoft SQL Server 2000
-
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.
-
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/
-
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
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply