Posted by Greg D. Moore \(Strider\) on 09/12/07 21:06

"info" <informatyk@fitness[CUT]authority.pl> wrote in message
news:fc8rq8$837$1@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

• Next in forum: Re: strange error: ran out of internal resources
• Prev in forum: strange error: ran out of internal resources
• Thread view: Re: import database to another server - howto

[Reply to this message]