import database to another server - howto

#1

How import database mysql to mysql server 2005?

--
magix

#2

"info" <informatyk@fitness[CUT]authority.pl> wrote

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

import database to another server - howto

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

import database to another server - howto - 09-12-2007 , 08:30 AM

Re: import database to another server - howto - 09-12-2007 , 04:06 PM