Re: Transfer large data (3 million) rows from MSSQL server to MySQL server
Posted by: Dmitry Tolpeko
Date: April 09, 2009 08:42AM

Hi Kalpak,

>>>2) I cannot take database dump as the destination database is on MySQL and not MSSQL

As an option, you can try SQL Server BCP utility to export the data into a flat file, and then use MySQL LOAD DATA INFILE command to import into MySQL.

There may be issues with data formats depending on column types.

BCP exports with TAB column delimiters, so load command can be as follows

LOAD DATA LOCAL INFILE 'C:\\Data\\orders.txt'
INTO TABLE orders
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\r\n'

You put this command to a file (order.ldi) and run it from the mysql utility:

mysql.exe < order.ldi


Kind regards, Dmitry Tolpeko
--
SQLWays - T/SQL stored procedures, triggers, DDL, data migration from SQL Server/Sybase to MySQL
http://www.ispirer.com/products/mysql-migration

Options: ReplyQuote


Subject
Written By
Posted
Re: Transfer large data (3 million) rows from MSSQL server to MySQL server
April 09, 2009 08:42AM


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.