Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help export data from mysql to sql server

Status
Not open for further replies.
karche168

karche168

Technical User
Jan 7, 2004
12
US
I have mysql and sql server on the Win2003 server and try to export data from mysql to sql server. I am using either DTS or export and import tool to export data using mysql ODBC driver but neither of them are working. The table I have is about 15 million rows. It seems it is trying to validate the data in transformation screen and put all the data in memory, the CPU reaches 100% and memory is keep going up.
Any suggest how can I do it? Thanks
 
Status
Not open for further replies.

Similar threads

E
  • Locked
  • Question
MySQL calculator tools
Replies
0
Views
265
EdZzy
E
lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
476
lupidol
lupidol
lupidol
  • Locked
  • Question
mysql cannot add rows with "UNION" 1
Replies
5
Views
431
Chris Miller
Chris Miller
dylim
  • Locked
  • Question
SQL_CALC_FOUND_ROWS still runs in MySQL 8.0.29
Replies
2
Views
496
dylim
dylim
soushi01
  • Locked
  • Question
MySQL replication slave server re-sync issue
Replies
0
Views
235
soushi01
soushi01

Part and Inventory Search

Sponsor

Back
Top