Skip to content
No results
We use cookies to ensure that we give you the best experience on our website.

# Translate SQL query between different databases

Translate SQL query between different databases is a very big topic, and there is no such tool available there can do all jobs for you automatically.

Here we provide some guidelines and little utilities(based on general sql parser) to help you to convert SQL statements from one RDBMS implementation to another.

- DDL(Data Definition Language)
  - Datatype
    - ANSI SQL datatypes
    - Oracle datatypes
    - SQL Server datatypes
- Select statement
  - Join conversion
    - Rewrite Oracle propriety joins to ANSI SQL compliant joins
    - Rewrite SQL Server propriety joins to ANSI SQL compliant joins
- SQL functions
- Object name

### 2 Comments

1. […] Datatypes conversion is one of the most important things you need to consider when migrate your appliation from one database to the other. This is one of the series of articles that we talking about translate SQL query among different databases. […]

2. […] This is one of the series of articles that we talking about translate SQL query among different databases. […]

Comments are closed.