Try SQLyog at http://www.webyog.com/sqlyog
I have used to import lots of data from SQL Server to
MySQL.
Karam
--- Martin Gainty <[EMAIL PROTECTED]> wrote:
> The official mySQL response is that you are
> overflowing the maxlength
> attribute
> Although there are many posts where SQLServer to
> MySQL have caused this
> error
> the solutions I have seen say go plain text and
> import using LOAD DATA
> INFILE
> Martin
> ----- Original Message -----
> From: "David Alonzo" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, August 13, 2003 4:30 PM
> Subject: SQL Server 2000 to mySQL Server
>
>
> > I'm trying to do an export from an SQL Server 2000
> Database to and ODBC
> driver pointed to a mySQL Server Database. The
> export works if there is at
> least one record in the mySQL table. If the mySQL
> table is empty it gives
> an error that looks like this:
> >
> > Insert error, column 1 ('field1', DBTYPE_STR),
> status 6: Data overflow.
> >
> > The strange part is that the export works
> perfectly fine as long as there
> is one record in the mySQL table, if there are no
> records in the table, I
> get the error above.
> >
> > Thank you for your help.
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
>
http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
>
http://lists.mysql.com/[EMAIL PROTECTED]
>
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
