RE: MSSQL Transactional Replication to MySQL

2003-02-06 Thread Jonathan Bedford
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 publi

RE: MSSQL Transactional Replication to MySQL

2003-02-05 Thread Jonathan Bedford
Hi Thanks for the information, my Microsoft SQL DBA is looking the DTS VB Script stuff. I will post the information if it works Cheers -- Jonathan Bedford Quoting Victor Pendleton <[EMAIL PROTECTED]>: > In the DTS engine you can write a VB script to handle the quotations during > the trans

RE: MSSQL Transactional Replication to MySQL

2003-02-04 Thread Victor Pendleton
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, Februar