Has anyone ever imported data from a MySql database on a linux server?
I know almost nothing about Linux so I have no idea how to get started
accessing the database with SQL from my SQL Server in order to do an import.Hi
Install a MySQL ODBC/OLE DB driver on your Windows Server.
Then use DTS like normal, but your source is the MySQL database (driver is
the driver you installed) and your destination is your SQL Server.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Florida" <noneavailable@.hotmail.com> wrote in message
news:%23PwNOHgyFHA.460@.TK2MSFTNGP15.phx.gbl...
> Has anyone ever imported data from a MySql database on a linux server?
> I know almost nothing about Linux so I have no idea how to get started
> accessing the database with SQL from my SQL Server in order to do an
> import.
>
No comments:
Post a Comment