Skip navigation links

MySQL Forums :: Microsoft SQL Server :: Data transfer from MS SQL to MySQL


Advanced Search

Data transfer from MS SQL to MySQL
Posted by: Murtaza Millwala ()
Date: April 20, 2005 10:21PM

Hello,

I have been assigned a task to transfer data from MS SQL server table to a MYSQL server table. I am using MYSQL 4.1 and SQL Server 2000.

The table name in SQl and MYSQl including the attribute names have been kept same.
I have tried changing the data types in both as well changing engine types for MYSQL table.

The table name is Store_Details

Attributes for MS SQL

Store_ID int NOT NULL,
Address_Line1 varchar(100),
Address_Line2 varchar(100) NULL,
Suburb varchar(50) NULL,
State varchar(50) NULL,
Postcode varchar(5) NULL,
Country varchar(50) NULL,
Telephone varchar(20) NULL,
Fax varchar(20) NULL,
Email varchar(100) NULL,
Primary key (Store_ID)

Attributes for MYSQL

Store_ID mediumint NOT NULL,
Address_Line1 varchar(100),
Address_Line2 varchar(100) NULL,
Suburb varchar(50) NULL,
State varchar(50) NULL,
Postcode varchar(5) NULL,
Country varchar(50) NULL,
Telephone varchar(20) NULL,
Fax varchar(20) NULL,
Email varchar(100) NULL,
Primary key (Store_ID)

Have tried using text and longtext as datatype for MYSQL Store_Details table

Errors I get using varchar in MYSQL table Store_Details:

"Insert error 6 on DBTYPE_STR 'Address_Line1' data overflow"

Error I get when I use longtext as datatype for MYSQL Store_Details table

"The number of failing rows exceed the maximum specified"

Can someone please help me to solve this problem.

The data needs to be transferred on a regular basis. Have tried using DTS package, but it generated the errors above.

Can someone please advise me on how to solve this problem.

Thank you.

Sincerely,

Murtaza Millwala

Options: ReplyQuote


Subject Written By Posted
Data transfer from MS SQL to MySQL Murtaza Millwala 04/20/2005 10:21PM
Re: Data transfer from MS SQL to MySQL Murtaza Millwala 04/25/2005 05:34PM
Re: Data transfer -- Problem temporarily resolved Murtaza Millwala 04/27/2005 07:21PM
Re: Data transfer -- Problem temporarily resolved Bob Baran 07/14/2005 04:51PM
Re: Data transfer -- Problem temporarily resolved schwarzer 07/25/2005 05:56AM
Re: Data transfer -- Problem temporarily resolved Edwin DeSouza 07/25/2005 09:22AM
Re: Data transfer -- Problem temporarily resolved Rajani Raja 07/25/2005 10:53AM
Re: Data transfer -- Problem temporarily resolved schwarzer 07/27/2005 02:52AM
Re: Data transfer -- Problem temporarily resolved Rajani Raja 07/25/2005 10:27AM


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.