RE: MSSQL Transactional Replication to MySQL

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

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 dur

MSSQL Transactional Replication to MySQL

2003-02-04 Thread Jonathan Bedford
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 qu

Question about Table_Options

2003-01-31 Thread Jonathan Bedford
Hi When creating a table can you use multiple Table_Options? The O'Reilly "Managing & Using MySQL" show on page 288 a table been created with two options "...)AUTO_INCREMENT = 1, TYPE=InnoDB;" But the MySQL manual says "or":- table_options: TYPE = {BDB | HEAP | ISAM | InnoDB | MERGE |

Question about Table_Options

2003-01-31 Thread Jonathan Bedford
Hi When creating a table can you use multiple Table_Options? The O'Reilly "Managing & Using MySQL" show on page 288 a table been created with two options "...)AUTO_INCREMENT = 1, TYPE=InnoDB;" But the MySQL manual says "or":- table_options: TYPE = {BDB | HEAP | ISAM | InnoDB | MERGE |