Re: Linking to MySQL
From: Tudor Sofron (tudor.sofron_at_mydomain.com)
Date: 01/25/05
- Next message: Igor Marchenko: "Re: Accessing jobs in EM"
- Previous message: sam: "Re: Password's case sensitivity"
- In reply to: Shane: "Linking to MySQL"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 25 Jan 2005 19:31:26 +0200
Hi,
in order to import data from mysql you'll need the followind:
- DSN to MYSQL Server using MyODBC-3.51.06 drivers
- Linked Server to the DSN
the following script:
--sp_tables_ex 'linked_server_name'
use [dababase]
dbcc traceon (8765)
if object_id ([table to import]) is not null drop table dbo.[table to
import]
select * into dbo.[table to import] from openquery ([linked_server_name],
'select * from [table to import] )
Tudor
"Shane" <Shane@discussions.microsoft.com> wrote in message
news:D8F7180E-BCE2-4CBD-BDE7-9DB99301D8DC@microsoft.com...
> Hi,
>
> I have to install a SQL 2000 server. Currently there is a MySQL 4.1
> server
> and I want to link to the server.
>
> I create an ODBC connection, called LinuxBox, to the MySQL server and the
> connection tests successfully but when I try to link the server, I cannot
> get
> access to the tables and have tried all the security options.
>
> If I use MySQL's Administrator from the SQL server, this connects
> successfully as well so I don't see to much problem with the security.
>
> The linked server setup contains the option "Microsoft OLE DB Provider for
> ODBC Drivers" and "LinuxBox" (name of the system dsn).
>
> Is there any other info I need to add in?
>
> Any help would be greatly appreciated as it would make my life a lot
> easier
> in the migration.
>
> Shane
- Next message: Igor Marchenko: "Re: Accessing jobs in EM"
- Previous message: sam: "Re: Password's case sensitivity"
- In reply to: Shane: "Linking to MySQL"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
