Procedural Porting tools from Oracle to SQLServer

• tlc

  SSC Enthusiast

  Points: 142

  More actions

  April 27, 2004 at 10:19 am

  #84180

  I am beginning to scope a project to port from Oracle9i (Using packages) to SQLServer 2000.

  Schema porting is not my biggest problem, but porting the SQL Procedures and mostly the packages we used in Oracle9i.

  Has anyone have any good recommendations?

• David Scotland-132255

  SSCertifiable

  Points: 5599

  More actions

  April 27, 2004 at 1:06 pm

  #504387

  You could have a look at this

  http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm

  Also do note there is a big difference in the way triggers are implemented to. So if you use them they will require a lot of work.

  Good luck.

  Dave

• Dev7

  SSC Veteran

  Points: 270

  More actions

  April 28, 2004 at 5:35 am

  #504471

  I don't know but just wondering if Oracle's transparent gateway for SQL Server might be able to help here.