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

Error On Import : Incorrect Specifier For Column 'id'

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Error On Import : Incorrect Specifier For Column 'id'

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • August 20, 2009 at 1:47 am #11641
      dsmania
      Member

      Hello. I'm in trial mode with SQLYog and I'm running into a problem importing tables from our MSSQL database.

      The error message received is Incorrect specifier for column 'ID'.

      The datatype for this column is numeric, and it's set to auto-increment.

      After doing some research, I discovered that mySQL does not support auto-increment on numeric fields – only integer fields.

      While I can definitely convert the data type on all my tables, I was hoping that this import program would convert data types like this automatically…as needed.

      Am I missing something? Perhaps a setting somewhere?

      Thanks!

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