I have a Microsoft SQL Server database(tables, relationships and data).
But now I want an exact same copy of this database in Oracle.
I was thinking there may be some sort of a tool or converter that could generate Oracle sql scripts that I could run to create and populate my new Oracle database.
Is this kind of thing possible?
And how can I achieve this ?
-
possible duplicate of Move Sql server 2005 to Oracle?Conrad Frix– Conrad Frix2011-05-02 16:24:08 +00:00Commented May 2, 2011 at 16:24
-
@Conrad - and the question you reference is a duplicate of this one: stackoverflow.com/questions/694133/… which also points out that stored procedures can be a problem as no automatic tool will be able to convert those from T-SQL to PL/SQL (aomthing I missed in my answer)Tony– Tony2011-05-02 22:49:14 +00:00Commented May 2, 2011 at 22:49
Add a comment
|
1 Answer
Your best bet is to use a DB modelling tool which can reverse engineer your SQL Server database and then generate a script to recreate it in Oracle.
DB Designer Fork can do this for you and is Open Source.
