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]
Re: SQL Server 2000 to mySQL Server
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]
Re: SQL Server 2000 to mySQL Server
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]
Re: how to convert SQL Server 2000 database to MySQL?
Greetings What you need is a tool called SQLyog ( it has the best ODBC import utility in the market ). A very good tutorial can be found at http://www.devshed.com in the MySQL section. Do tell me how was your experience? Karam ( A satisfied user of SQLyog ) --- kumar mcmillan <[EMAIL PROTECTED]> wrote: > Hi. > First, you will be happy to know that I am migrating > a client to > PHP/MySQL from ASP/MSSQL. This is for reasons of > future preservation, > cost, security, efficiency, et cetera. The problem > is, I don't > currently have a PC and $$ to run Windows 2000 > server on. I have been > sent the MDF and LDF database files by the client... > Does someone know > of a way to convert those files to SQL without > running Windows to do > it? If not, is there an SQL-like format that SQL > Server will save as > that I can request from the client? Or is there > an application > (Windows or anything) that someone can recommend to > make this > conversion? I should point out that this is a > simple database with no > stored procedures or anything fancy. > > thanks for taking the time to read this, > Kumar > > > -- > 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]
Re: how to convert SQL Server 2000 database to MySQL?
http://hotwired.lycos.com/webmonkey/99/21/index2a_page6.html?tw=programming An example of PHP reading MySQL DB Hth, Martin - Original Message - From: "kumar mcmillan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, July 26, 2003 3:43 PM Subject: how to convert SQL Server 2000 database to MySQL? > Hi. > First, you will be happy to know that I am migrating a client to > PHP/MySQL from ASP/MSSQL. This is for reasons of future preservation, > cost, security, efficiency, et cetera. The problem is, I don't > currently have a PC and $$ to run Windows 2000 server on. I have been > sent the MDF and LDF database files by the client... Does someone know > of a way to convert those files to SQL without running Windows to do > it? If not, is there an SQL-like format that SQL Server will save as > that I can request from the client? Or is there an application > (Windows or anything) that someone can recommend to make this > conversion? I should point out that this is a simple database with no > stored procedures or anything fancy. > > thanks for taking the time to read this, > Kumar > > > -- > 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]
Re: how to convert SQL Server 2000 database to MySQL?
At 05:43 PM 7/26/2003 -0500, kumar mcmillan wrote: Hi. First, you will be happy to know that I am migrating a client to PHP/MySQL from ASP/MSSQL. This is for reasons of future preservation, cost, security, efficiency, et cetera. The problem is, I don't currently have a PC and $$ to run Windows 2000 server on. I have been sent the MDF and LDF database files by the client... Does someone know of a way to convert those files to SQL without running Windows to do it? If not, is there an SQL-like format that SQL Server will save as that I can request from the client? Or is there an application (Windows or anything) that someone can recommend to make this conversion? I should point out that this is a simple database with no stored procedures or anything fancy. thanks for taking the time to read this, Kumar Have them export the tables as CSV files. You can then easily import them into MySQL. You will also want them to generate SQL scripts for each table so that you can see the MS-SQL that it takes to create those tables - this will give you the types and names of the columns... (CSV files can be generated to give you the names on the first line, but not the type). You _should_ be able to find compatible types for each column in order to import the data into MySQL. You _may_ need to do some scripting to convert things like date/time stamps from MS-SQL to MySQL... and you will need to pay attention to differences in functinality. This should get you started. Hope this helps, _M Pete McNeil (Madscientist) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
how to convert SQL Server 2000 database to MySQL?
Hi. First, you will be happy to know that I am migrating a client to PHP/MySQL from ASP/MSSQL. This is for reasons of future preservation, cost, security, efficiency, et cetera. The problem is, I don't currently have a PC and $$ to run Windows 2000 server on. I have been sent the MDF and LDF database files by the client... Does someone know of a way to convert those files to SQL without running Windows to do it? If not, is there an SQL-like format that SQL Server will save as that I can request from the client? Or is there an application (Windows or anything) that someone can recommend to make this conversion? I should point out that this is a simple database with no stored procedures or anything fancy. thanks for taking the time to read this, Kumar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL coexisting on same server as MS SQL Server 2000
Would there be any reason why I couldn't have MySQL running on the same box as SQL Server 2000? Thanks, Steve _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL-Front: How Do I Get 2 Open Connection-Windows To Enable Opt ion: "EXPORT TABLES TO ANOTHER HOST/DB (Like MS SQL Server 2000)"
In MySQL-Front 2.5: How Do I Get Two Open Connection-Windows To Enable Option to "EXPORT TABLES TO ANOTHER HOST/DB (Like Microsoft SQL Server 2000)" - Can It Be Done ? This message and any attachments are confidential and intended solely for the addressee. Any unauthorized use, alteration or dissemination is prohibited. Lawyers Access Web (Pty) Ltd. accepts no liability whatsoever for any loss, whether it be direct, indirect or consequential, arising from information made available and actions resulting there from.
Problem importing data from SQL server 2000 to mysql
Hi guys, I want to migrate data from SQL Server 2000 to Mysql.I have two problems. First is easy one, First problem is to migrate big fields which had type varchar(7900) or so I tried using Text datatype of mysql, is that the right one or I should have used BLOB. That field doesnt contain any image informtaion or any special information. Only at one place it stores data which is a "email" I am using command LOAD DATA INFILE "c:/mysql/roma/mailmessagetext_table.txt" INTO TABLE mailmessagetext_table; Data which i export from sql server is tab dilimited . Another problem is, For the field messagetext - varchar(7900), it doesnt migrate the only migrated few characters, as this field stores emails. so it has some enter chanracters. SQL server saves them as a special character. But when i try to import, then Mysql cuts the field at that special character, and does not take rest of string. e.g., if i have data like dear roma, how are you thanks abc it will import only "dear roma," as it will find a enter character at the end. I tried using BLob field instead. I tried exporting data using pipe delimited , that does not work either. Please help Thanks Roma - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem importing data from SQL server 2000 to mysql
Hi guys, I want to migrate data from SQL Server 2000 to Mysql. My problem is to migrate big fields which had type varchar(7900) or so I tried using Text datatype of mysql, then I cant migrate data in that field I used command LOAD DATA INFILE "c:/mysql/roma/mailmessagetext_table.txt" INTO TABLE mailmessagetext_table; For the field messagetext - varchar(7900), it only migrated few characters, not the complete length Please help Thanks Roma - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem importing data from SQL server 2000 to mysql
Hi, I want to migrate data from SQL Server 2000 to Mysql. My problem is to migrate big fields which had type varchar(7900) or so I tried using Text datatype of mysql, then I cant migrate data in that field I used command LOAD DATA INFILE "c:/mysql/roma/mailmessagetext_table.txt" INTO TABLE mailmessagetext_table; For the field messagetext - varchar(7900), it only migrated few characters, not the complete length Please help Thanks Roma - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: SQL Server 2000
Yes it is, at $139 I think it is a supper apps, if you are not sure try the evaluation version -Original Message- From: Gerald R. Jensen [mailto:[EMAIL PROTECTED]] Sent: 06 January 2002 15:37 To: Norman Khine; Stan Lester Cc: Mysql Subject: Re: SQL Server 2000 You can't try http://www.appsolute.nl/heraut/ ... it is a restricted site. Must be a commercial package or subscription service. Gerald Jensen - Original Message - From: "Norman Khine" <[EMAIL PROTECTED]> To: "Stan Lester" <[EMAIL PROTECTED]> Cc: "Mysql" <[EMAIL PROTECTED]> Sent: Sunday, January 06, 2002 3:06 AM Subject: RE: SQL Server 2000 try http://www.appsolute.nl/heraut/ you can use importerscript to run db_dump.sql from you M$ SQL Server into dezign and then change the db type to mysql. hth Norman -Original Message- From: Stan Lester [mailto:[EMAIL PROTECTED]] Sent: 05 January 2002 18:35 To: [EMAIL PROTECTED] Subject: SQL Server 2000 Hi.. Is there any painless way or good documentation on how to convert a database from Micro$soft $QL 2000 into MySql? Thanks in advance for any directions you can point me to. Stan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL Server 2000
You can't try http://www.appsolute.nl/heraut/ ... it is a restricted site. Must be a commercial package or subscription service. Gerald Jensen - Original Message - From: "Norman Khine" <[EMAIL PROTECTED]> To: "Stan Lester" <[EMAIL PROTECTED]> Cc: "Mysql" <[EMAIL PROTECTED]> Sent: Sunday, January 06, 2002 3:06 AM Subject: RE: SQL Server 2000 try http://www.appsolute.nl/heraut/ you can use importerscript to run db_dump.sql from you M$ SQL Server into dezign and then change the db type to mysql. hth Norman -Original Message- From: Stan Lester [mailto:[EMAIL PROTECTED]] Sent: 05 January 2002 18:35 To: [EMAIL PROTECTED] Subject: SQL Server 2000 Hi.. Is there any painless way or good documentation on how to convert a database from Micro$soft $QL 2000 into MySql? Thanks in advance for any directions you can point me to. Stan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: SQL Server 2000
try http://www.appsolute.nl/heraut/ you can use importerscript to run db_dump.sql from you M$ SQL Server into dezign and then change the db type to mysql. hth Norman -Original Message- From: Stan Lester [mailto:[EMAIL PROTECTED]] Sent: 05 January 2002 18:35 To: [EMAIL PROTECTED] Subject: SQL Server 2000 Hi.. Is there any painless way or good documentation on how to convert a database from Micro$soft $QL 2000 into MySql? Thanks in advance for any directions you can point me to. Stan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL Server 2000
Stan: I don't know as I would call anything involving MSSQL Server 'painless", but it can be done. Do a search of the list archive (http://lists.mysql.com/), looking for 'SQL7' or 'MSSQL'. There have been dozens of posts over the last couple of years describing different ways to approach the task. You should be able to use the same techniques port MSSQL Server 2000. Regardless of the technique you use, there will be some editing required on the table creation scripts. When you get to that, the MySQL Manual is your friend. Gerald Jensen - Original Message - From: "Stan Lester" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, January 05, 2002 12:35 PM Subject: SQL Server 2000 Hi.. Is there any painless way or good documentation on how to convert a database from Micro$soft $QL 2000 into MySql? Thanks in advance for any directions you can point me to. Stan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL Server 2000
Hi.. Is there any painless way or good documentation on how to convert a database from Micro$soft $QL 2000 into MySql? Thanks in advance for any directions you can point me to. Stan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Export to MySQL from SQL Server 2000
Hi, Newbie to MySQL here. I am trying to export tables from SQL Server to MySQL set up on a virtual server and manage to create the tables when the fields contained within them are purely text, but the table creation fails when fields are type integer or type datetime. The error message is as follows - [TCX][MyODBC]You have an error in your SQL syntax near 'ID char (10) NULL, Job Ref integer NULL, JobTitle char (100) NULL, DateAdd' at line 2 I have just used the default settings for export from SQL Server 2000. All comments would be very gratefully received. Many thanks in advance, Chris Malloch _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
