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

converting oracle to mysql

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › converting oracle to mysql

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • October 11, 2004 at 9:09 pm #8602
      sanspeur
      Member

      I'm having problems using the odbc migration tool to convert data from oracle to mysql. When the '&' character is encountered in a field on the oracle side (as in 'Bob & Ted'), the column data is not carried over to MYSQL for that and each subsequent row.

      example

      Oralce data

      idno, first, last, amount, date

      1 Joe Jackson 100 03/03/04

      2 'A & B' Lastname 200 03/04/05

      3 Mary Young 300 01/01/01

      converts to

      1 Joe Jackson 100 03/03/04

      2 NULL Lastname 200 03/04/05

      3 NULL Young 300 01/01/01

      This only happens if I choose 'run immediatly'. If I save it to a SQL script it works and import later it works fine but the tables are huge so it would be speedier to be able to run immediately.

    • October 12, 2004 at 5:04 pm #16371
      Ritesh
      Member

      We will try to duplicate this problem at our end.

      We will revert back shortly.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.