import database to another server - howto

How import database mysql to mysql server 2005?

--
magix
info [ Mi, 12 September 2007 15:30 ] [ ID #1818462 ]

Re: import database to another server - howto

"info" <informatyk [at] fitness[CUT]authority.pl> wrote in message
news:fc8rq8$837$1 [at] 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
mooregr_deleteth1s [ Mi, 12 September 2007 23:06 ] [ ID #1818466 ]
Datenbanken » comp.databases.ms-sqlserver » import database to another server - howto

Vorheriges Thema: Deadlock in SQL Server 2005 sp2 running queries using temp tables or table variables
Nächstes Thema: SQL Server error