MySQL Subscriber

Hi,

SQL Server 2005 sp2


The problem I face is that I try to set up a Transactional Replication
between sql as a Publsher and MySQL as a Subscriber.

When I use sp_browsereplcmds to see the cmd that is generated by the
LogReader I see the bellow INSERT statment. MySQL fails on the square
brackets with a syntax error.

insert into [T3] ([COL1],[COL2]) values (1,'abc')


The article is added as follow:
EXEC sp_addarticle

@publication = @pub

,@article = @TableName

,@source_owner = N'dbo'

,@destination_owner = NULL

,@source_object = @TableName

,@destination_table = @TableName

,@type = N'logbased'

,@creation_script = NULL

,@description = NULL

,@pre_creation_cmd = N'none' --none --drop

,@schema_option = 0x000000000803FFDF

,@status = 8 --Includes the column name in INSERT statements.

,@vertical_partition = N'false'

,@ins_cmd = 'SQL'

,@del_cmd = 'SQL'

,@upd_cmd = 'SQL'

,@filter = NULL

,@sync_object = NULL





Thanks,

Yan