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

Varchar Limitation In Migration Toolkit Powertool

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Varchar Limitation In Migration Toolkit Powertool

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • October 19, 2006 at 6:41 am #22790
      peterlaursen
      Participant

      I tried to reate a varchar(70000) on SQL server. It is not possible!

      Are your source data VARCHAR or TEXT?

      Starting from next release TEXTs from MS-SQL will always be imported a TEXT – also with MySQL 5. However you may need to change to MEDIUMTEXT or LONGTEXT yourself if the length of data demands it.

    • October 20, 2006 at 3:07 pm #22791
      Richard J Lacroix
      Member
      peterlaursen wrote on Oct 19 2006, 02:41 AM:
      Are your source data VARCHAR or TEXT?

      The MS SQL source was TEXT I believe, because the size was 2147483647, a field used to hold user comments. I can't confirm at the moment because the database is now detached from my development environment and running on the production server.

    • October 21, 2006 at 5:24 am #22792
      peterlaursen
      Participant

      You can just change the mapping in the wizard.

      There is no need for this weird manouvre …

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