Hi My DBA has created a DTS package that works between two MS SQL machines, successfully adding characters at either side of the source data on the publication. However, we have a problem when trying to replicate to MySQL.
If we check the "transform data" box when creating the SQL Server publication, later on when it comes to creating the subscription within the same wizard, SQL Server does not give us the ODBC connection to MySQL as a subscription option. We've tried altering the succesful SQL Server subscription DTS package so that the subscription connection points towards the MySQL database subscriber instead of SQL Server, but this just leads to a muddle whereby the distributor is looking for SQL Server stored procedures on the MySQL box. Do you have any suggestions for getting around this? It seems fairly embedded in SQL Server logic - check a certain box, then don't get the option you need later on. If I was suspicious I'd say that Microsoft didn't want us to be able to transform data out of SQL Server! Cheers -- Jonathan Bedford Quoting Victor Pendleton <[EMAIL PROTECTED]>: > In the DTS engine you can write a VB script to handle the quotations during > the transfer. I replicate from MS SQL to MySQL using Java and came across > the same issue. Let me know if you need any help. > > -----Original Message----- > From: Jonathan Bedford [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 03, 2003 2:58 PM > To: [EMAIL PROTECTED] > Subject: MSSQL Transactional Replication to MySQL > > > Hi > > Has anyone managed to get Microsoft SQL Server (2000 (SP2)) to replicate > data to MySQL (3.23.49) via Microsoft heterogeneous replication & MySQL > ODBC > Driver (3.51)? > > Deletions at the MS end replicate to the MySQL Successfully, BUT > > Insertions and updates fail, it seem to be a problem with quotes `'" > > Both servers are running in ANSI mode and the MySQL tables are InnoDB. > > The trace from the MyODBC driver show that no quotes are been used around > the values. > > Any Ideas? > > Jonathan > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > ------------------------------------------------- This mail sent through IMP: http://horde.org/imp/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
