{"id":401,"date":"2010-07-26T21:27:37","date_gmt":"2010-07-27T02:27:37","guid":{"rendered":"http:\/\/www.dpriver.com\/blog\/?page_id=401"},"modified":"2022-07-23T03:34:09","modified_gmt":"2022-07-23T08:34:09","slug":"translate-sql-query-between-different-databases","status":"publish","type":"page","link":"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/translate-sql-query-between-different-databases\/","title":{"rendered":"Translate SQL query between different databases"},"content":{"rendered":"

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.<\/p>\n

Here we provide some guidelines and little utilities(based on general sql parser<\/a>) to help you to convert SQL statements from one RDBMS implementation to another.<\/p>\n

\n
- DDL(Data Definition Language)\n
  \n
  - Datatype\n
    \n
    - ANSI SQL datatypes<\/a><\/li>\n
    - Oracle datatypes<\/a><\/li>\n
    - SQL Server datatypes<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n
    - Select statement\n
      \n
      - Join conversion\n
        \n
        - Rewrite Oracle propriety joins to ANSI SQL compliant joins <\/a><\/li>\n
        - Rewrite SQL Server propriety joins to ANSI SQL compliant joins<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n
        - SQL functions<\/li>\n
        - Object name<\/li>\n
          <\/ul>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

          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 <\/p>\n","protected":false},"author":1,"featured_media":0,"parent":235,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"gsp_sql_translate_tt.php","meta":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"yoast_head":"\nHelp you to make better use of General SQL Parser<\/title>\n\n\n\n\n\n\n\n\n\n\n\n