SQL Converter

Database and SQL Migration Tools :
=========================

This site really worked for me and it can convert a bunch of different DDL commands from Oracle, MySql, MS-SQL Server, Sybase and others. http://www.sqlines.com/online

SQLines provides database migration tools:

Database Schema (DDL) Conversion
Server-Side Business Logic (Stored Procedures, Functions, Packages and Triggers) Conversion
Queries, Views and SQL Scripts Conversion
Embedded SQL Conversion in C/C++, C#, Java, PowerBuilder, VB/VB.NET, ASP/ASP.NET, Perl/PHP and COBOL Applications
Database API Conversion (CTLIB, DBLIB, ESQL/C, ODBC, JDBC, Pro*C, Pro*COBOL, OCI)
Data Transfer and Validation

http://www.sqlines.com/online

Please note the disclaimer below the tool:

Note. SQLines Online is a unrestricted version for EVALUATION USE ONLY. For use in projects, please obtain a license.
Oracle Syntax : –
==============

CREATE TABLE “DBVERSIT”.”PS_RELN_VSBL”
( “USER_GEID_ID” VARCHAR2(10 BYTE),
“RELN_KEY_ID” NUMBER(14,0),
“RELN_NR” VARCHAR2(30 BYTE),
“ISRT_TS” TIMESTAMP ,
“UPD_TS” TIMESTAMP ,
“ISRT_USER_ID” VARCHAR2(10 BYTE),
“UPD_USER_ID” VARCHAR2(10 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE “APPN_DATA_01” ;
MySQL syntax after converting thru tool :
========================================

CREATE TABLE “DBVERSIT”.”PS_RELN_VSBL”
( `USER_GEID_ID` VARCHAR(10),
`RELN_KEY_ID` BIGINT,
`RELN_NR` VARCHAR(30),
`ISRT_TS` DATETIME,
`UPD_TS` DATETIME,
`ISRT_USER_ID` VARCHAR(10),
`UPD_USER_ID` VARCHAR(10)
) ;