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

moving from MSSQL to MySQL

forums › forums › moving from MSSQL to MySQL

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • May 14, 2003 at 9:24 pm #14267
      ikaufman
      Member

      Hi,

      I faced the same problem converting from MSAccess. SQLyog copy routine doesn't copies indexes and autoincremets (at least I found it works so with Access). So I have got mySQL table with INT field instead of auto-increment. When I tried to convert this field to auto-inc, values have been renumbering sequentally as I have gaps in numbering.

      One solution I see is to index this field as UNIQUE – in this case values aren't changing. But if you will add new rows you should fill this field by yourself (i.e. using MAX(..)+1).

    • May 15, 2003 at 7:00 am #14268
      Shadow
      Member

      Well, Themetal, you haven't tried hard enough! In ODBC import choose table copy. Then you will see all the tables in your db in a list where you can specify which to import. After selecting a table, a button will appear in the “Transform” column. Just click it and then check the auto increment field in those columns you need it! Oh, and you can add indices as well!

    • May 15, 2003 at 11:01 am #14269
      ikaufman
      Member

      Thanks, Shadow!

      It works. I was in hurr too much 😀

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