Conversion of Oracle to Sqlserver

Asked

Viewed 679 times

1

Context: Currently I work in a system that uses the database , but now I’m going to need the system to use .

My goal is to convert DDL and DML for , I see there are some differences like:

Number for Numeric
Varchar2 for Varchar
Data for DataTime

However I wanted to do it automatically, or at least have the equivalences more fully to help in this process.

It would also be interesting to comment on the difficulty I may have for I also have Triggers, Procedures, Functions, etc..

Thank you

sql sql-server oracle conversion

  • I think that there is no direct solution to what you want. You have some experience with programming with Java?

  • No, but if you have any idea.. even in Java, it’s something already :)

  • Right. In java there is JPA technology created to make programs database-independent. You create the classes and use Annotation and from the classes the tables in the database are created. Here enters my idea JPA also allows that from a database the classes are created. My idea is to create the classes from JPA and with these classes, changing the connection, create the tables in SQL Server.

  • 1

    In the data question I think that the import/export of SQL Server itself can query in Oracle and load in SQL. Otherwise you can create a java program just for this. Now Trigger, Procedure and Function will have to converted in the same hand.

  • Interesting @Krismorte thanks

1 answer

0


I found a solution that solves my problem, the Sqlines SQL Converter, does conversions of various types of banks:

Sqlies SQL Converter is an open source tool (Apache License 2.0) that allows converting database schema (DDL), queries and DML, views, stored procedures, Packages, functions and triggers between Microsoft SQL Server, Oracle, IBM DB2, Mysql , Postgresql, Sybase, Informix, Teradata, Netezza and Greenplum.

The same one still has a Converter Online, but can also be downloaded to trial version. Meanwhile, it is paid.

Still you solved my problem.

Browser other questions tagged sql sql-server oracle conversion

You are not signed in. Login or sign up in order to post.