4

I'm looking for an application that can convert queries, schemas, etc from one SQL-like database (e.g. MySQL) to another (e.g. Oracle). It must be able to support conversion of pretty much everything (like views, procedures, triggers), be free of charge, and it would also be nice if it's cross-platform or a web-application.

Databases I need support for are:

  • Oracle
  • MySQL
  • H2
  • Microsoft SQL Server
  • SQLite
Improve this question
1
  • When your target is oracle, the oracle migration tool can do it quite well for almost any type of database object. I have not yet seen a tool that is truly database independent in both conversion directions. However when you correctly design the environment you can easily run the same software on most platforms.
    – Guido Leenders
    Commented Apr 8, 2014 at 19:46

2 Answers 2

Reset to default
1

This Oracle Transparent Gateway from Ceiton goes from MSSQL to Oracle, but I don't know about pricing.

Improve this answer
1

With RazorSQL, you can convert schemas from one database to another. I don't know if it'll help you with ad hoc SQL, though. It is not free, but has a 30 day trial.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.