December 3, 2002 at 7:11 am
I'd like to be able to select certain tables in a SQL Server 2000 database and upload them to the corresponding tables in a remote MySql database.
How would I go about facilitating that?
Thank you.
December 3, 2002 at 7:31 am
You will need an OLE or ODBC driver for MySQL then you should be able to use Export wizrd to pick and choose the data to move. Or if done regularly create a DTS package to handle.
December 3, 2002 at 8:08 am
MyODBC is a (free) ODBC driver for MySQL. I have used it without problems (version 2.50.39.00).
It can be downloaded from http://www.mysql.com/downloads/api-myodbc.html.
December 5, 2002 at 8:13 pm
You can also slug it out with BCP, unload from SS and BCP back into MySS.
This avoids any security concerns if you don't want to /can't add a linked server.
Also, if you have an ODBC driver, you can use OpenRowSet() to get stuff back from MySS. It won't help your current request but might be helpful later on.
December 6, 2002 at 2:01 am
That is an alternative way of doing. Exporting everything to a plain text file and inserting it back into MySQL.
There is a command, LOAD DATA INFILE, that does this in MySQL.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply