Importing Data from MYSQL

Last Post 17 Mar 2006 10:28 AM by Epic619Cycle. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
jstiebe
New Member
New Member

--
10 May 2005 08:26 AM
What is the best way to import data from MYSQL to a SQL2000 database on a nightly basis? Can I use DTS connecting to MYSQL with an ODBC driver? Where can I get the MYSQL ODBC driver? Or is there a better way? Thanks.
Epic619Cycle
New Member
New Member

--
17 Mar 2006 10:28 AM
i've tried this, however DTS gets a memory error when you attempt to import a large table.. 2+million records.. any workaround? MySQL forums pretty much suck.. They can't even help with a simple Select to output file that I can BCP. Their manual says its supposed to do one thing, but it does another and they can't seem to answer the problem...MySQL = SuCks


Acceptable Use Policy
---