MySQL Forums
Forum List  »  Microsoft SQL Server

SQL Server to MySQL
Posted by: Robin Oaks
Date: January 10, 2013 01:58PM

Migrating a SQL Server 2008 R2 database to MySQL Server 5.5 using Workbench 5.2 throws create table error for varchar(max) data types.

The CREATE TABLE script generated for the SQL Server fields of type varchar(MAX) are defined as just varchar with no size like varchar(255). These should be TEXT or one of its variation and when I edit to TEXT, it works. Is there a setting or configuration somewhere that I can set to persist this correction?

Edited 1 time(s). Last edit at 01/10/2013 01:59PM by Robin Oaks.

Options: ReplyQuote

Written By
SQL Server to MySQL
January 10, 2013 01:58PM
January 11, 2013 10:34AM
January 11, 2013 02:10PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.