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

Fk Error When Using Migration Took Kit

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Fk Error When Using Migration Took Kit

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • September 6, 2006 at 5:22 pm #9847
      dor
      Member

      Good Morning.

      I am trying to use the Migration Tool Kit to migrate a database from MS SQL to MySql. I am receiving an error on the FK creations:

      Sql: ALTER TABLE `UserInformation` ADD FOREIGN KEY `FK_UserInformation_UserLevels`(`userlevel`) REFERENCES `UserLevels`(`id`) ON DELETE RESTRICT ON UPDATE RESTRICT

      Check C:Program FilesSQLyog Enterprisesja.log for complete error details.

      I have verified that both fields are of the same data type and both are signed (identity, right?)

      Not sure what I am missing.

      Thanks in advance.

    • September 7, 2006 at 12:12 am #22325
      peterlaursen
      Participant

      hmmm ..

      Do both fields have an index? That looks like a pretty trivial FK thing that should not normally create any problems! And both tables are InnoDB?

      “I am receiving an error on the FK creations” There is no more information about the error? an error no.? an error message?

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