Unsupported Screen Size: The viewport size is too small for the theme to render properly.

ODBC Import from ORACLE

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › ODBC Import from ORACLE

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • February 17, 2003 at 4:52 pm #7699
      gsantos
      Member

      While trying to import data from a ORACLE View into MySQL as a Table,

      all the NUMBER Columns ( in ORACLE ) were modified into 'decimal' and

      'shortened'.

      For example, Employe Number defined as NUMBER(5) was imported as

      Decimal (31,10).

      The Number 134, after ODBC Import, was shown as 99,9999999999.

      Is this a BUG or a feature ????

      If data Imported into a Table previouslly defined, everything goes well, only

      when Tables are created directly from the ODBC Import that happened.

      Another improvement should be a Function Tip in the SQL window. Being a

      12 year ORACLE user, I have some dificult in MySQL Function sintax. This

      could be a must.

      Otherwise, this is a wonderfull tool.

      Best Regards to all the SQLYoger's !!!!!

  • Author
    Posts
Viewing 0 reply threads
  • You must be logged in to reply to this topic.