MySQL Forums
Forum List  »  Oracle

Online customizable DDL/Queries conversion - open source project
Posted by: Dmitry Tolpeko
Date: February 17, 2011 06:47AM

I would like to introduce a new free online tool http://www.sqlines.com/online for DDL/queries conversion between Oracle, MySQL and many other databases.

Right now, it has a few built-in conversions, but it allows you to easily create new custom conversions.

For example,

1) NUMBER(p,s) to INT conversion when s is 0 or not specified is performed by the following template:

{
NUMBER($int[,0])
=>
INT
}

2) NUMBER(p,s) to DECIMAL conversion when s is not 0:

{
  NUMBER($int,$int2)
=>
  $if($int2 != 0)
  {
    $change(NUMBER, DECIMAL);
  }
}

The next steps are to extend the conversion language to allow easy and fast customizations, and create a large set of built-in templates that can be used by most users to do conversions.

Please send your feedback to support@sqlines.com

P.S. Download versions are also available for Windows/Linux.

Thank you,

Dmitry Tolpeko
--
SQLWays - DDL, SQL Scripts, Stored procedures and triggers migration for major databases (commercial tool)
http://www.ispirer.com

Options: ReplyQuote


Subject
Views
Written By
Posted
Online customizable DDL/Queries conversion - open source project
13026
February 17, 2011 06:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.