Replication from SQL Server 2000 to MySQL through ODBC

Sebastien Hinse

unread,

Mar 28, 2002, 4:27:21 PM3/28/02

to

Hello,

I am trying to replicate a single table from SQL Server
2000 to MySQL using ODBC. I have created a system data
source on the SQL Server machine with the MyODBC driver.
The data source points to the server running MySQL.

When I created my 1-table transactional publication, I
enabled the MySQL data source as a Subscriber. Now, I want
to create a new Push Subscribtion to that MySQL data
source, but it doesn't appear in the "Enabled Subscribers"
list.

From what I read in Books Online, it should work !?

Anyone has an idea ?

Thanks in advance.
Sebastien Hinse

Sebastien Hinse

unread,

Mar 28, 2002, 4:38:54 PM3/28/02

to

Hello again,

I just succeeded in creating the subscription. I had
selected to used "Queued updating" which seems to not
support heterogeneous subscribers.

Now, the distribution agent is failing because the
subscriber doesn't support transactions (viva MySQL)...
I'm trying to find out how to avoid using transactions,
but if anyone can help, please feel free to reply !

Regards,
Sebastien Hinse

>.
>

Michael Hotek

unread,

Mar 28, 2002, 9:09:45 PM3/28/02

to

You can't and no transaction support is a MAJOR failing of mySQL. Get rid
of replication and move to DTS. Or better yet, use a transformable
subscription. This basically slaps DTS on the end of a replication process.

--
Mike
SQL Server MVP
http://www.mssqlserver.com

Sebastien Hinse

unread,

Mar 29, 2002, 9:40:49 AM3/29/02

to

Hi Michael,

Thanks for the reply. I will try your suggestions.

Seb

>.
>

Nick Schueler MS

unread,

Mar 29, 2002, 4:12:29 PM3/29/02

to

Hi Sebastien
Your right, Queued Updating is not supported for an ODBC Subscriber. (Nor
does Immediate Updating)

The publication should be created for Heterogeneous subscribers. This
option will use the character BCP mode when delivering the snapshot.

I'm not sure what you mean by transactions. If you are referring to the
Insert/Update/Delete procedures that are created by default when creating a
transactional article, you will see that these options are not checked when
choosing Heterogeneous subscribers.

Nick Schueler

--------------------
| Content-Class: urn:content-classes:message
| From: "Sebastien Hinse" <shi...@ubisoft.com>
| Sender: "Sebastien Hinse" <shi...@ubisoft.com>
| References: <2f6901c1d69f$587c4d90$36ef2ecf@tkmsftngxa12>
| Subject: Replication from SQL Server 2000 to MySQL through ODBC
| Date: Thu, 28 Mar 2002 13:38:54 -0800
| Lines: 40
| Message-ID: <297001c1d6a0$f5717750$37ef2ecf@TKMSFTNGXA13>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
| Thread-Index: AcHWoPVxVWxGXm1RQdqRPiP8FZFvkQ==
| Newsgroups: microsoft.public.sqlserver.replication
| NNTP-Posting-Host: TKMSFTNGXA13 10.201.226.41
| Path: cpmsftngxa07!tkmsftngxs01!tkmsftngxs02!cpmsftngxa08
| Xref: cpmsftngxa07 microsoft.public.sqlserver.replication:27935
| X-Tomcat-NG: microsoft.public.sqlserver.replication

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

tushar

unread,

Apr 15, 2002, 6:16:16 AM4/15/02

to

>.
>

Narayana Vyas Kondreddi

unread,

Apr 15, 2002, 3:56:03 PM4/15/02

to

Did you make sure you enabled the publication for ODBC susbcribers (not just
SQL Server subscribers) while creating the publication?
--
HTH,
Vyas, MVP (SQL Server)
Check out my SQL Server website @
http://vyaskn.tripod.com/

"tushar" <tush...@rediffmail.com> wrote in message
news:217601c1e466$94336d80$a4e62ecf@tkmsftngxa06...

Chris Skorlinski (MS)

unread,

Apr 18, 2002, 4:10:40 PM4/18/02

to

I always get lost trying to add ODBC or Microsoft Access subscribers.
These are the steps you can use to add non-SQL Server subscribers to your
publication.

1) In the Create Publication Wizard, on the Specify Subscriber Types, check
and select Heterogeneous data sources.

2) Create and save the publication.

3) From the menu select Tools, then Configure Publishing, Subscribers, and
Distribution....

4) Select the Subscribers tab, then click on the New... button.

You will now be given the chance to add an ODBC data source as a Subscriber.

Hope this helps,

Chris Skorlinski, MCDBA
Microsoft SQL Server Support