468,248 Members | 1,513 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,248 developers. It's quick & easy.

import database to another server - howto

How import database mysql to mysql server 2005?

--
magix
Sep 12 '07 #1
1 2255
"info" <informatyk@fitness[CUT]authority.plwrote in message
news:fc**********@news2.task.gda.pl...
How import database mysql to mysql server 2005?

--
magix
MySQL != SQL Server.

So it's not clear what products you have in mind here.

If you can be more clear, I'm sure folks can give suggestions.

One possible way if you mean mysql to MS SQL Server 2005 is to try to get an
ODBC driver for the mysql db setup and set it up as a linked datasource and
SQL Server can pull against that with a SSIS (DTS) package.

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
Sep 12 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Randy | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.