May 29, 2015 at 9:39 am
Hi,
I just wanted to know what the easiest way would be to migrate a SQL Server 2012 database to Oracle?
Apart from the tables and views, the database also uses a number of stored procedures and functions which will also need to be migrated over onto Oracle.
I guess the problem with generating scripts for the database (right clicking database > tasks > generate scripts) is that the TSQL scripts will not run in Oracle which uses PSQL? Is this correct?
I have also considered using the import/export wizard. Do I need to install a feature to use this to export to Oracle?
Any help much appreciated.
May 29, 2015 at 9:56 am
No feature, just a rather large pile of manual work.
You'll need to take the table create statements and change the data types to match Oracle, you'll need to check every view to make sure it doesn't use T-SQL specific features and you'll need to rewrite every function and procedure in pl-sql.
There's no easy way
Oh, and then you need to test the app to make sure it doesn't break anywhere.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 29, 2015 at 10:00 am
Ok I was afraid you might say that.....thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply