SQL Server与Oracle的数据同步-性能调优

        as

网管论坛bbs_bitsCN_com

        select * from ORACLEDB..ROADSMS.PUBLISHLASTREC 网管网www_bitscn_com

        //ORACLEDB链接服务器名,ROADSMS为表空间名,PUBLISHLASTREC 为数据表名 网管朋友网www_bitscn_net

        create trigger trg_PUBLISHLASTREC_insert on PUBLISHLASTREC for insert 网管bitscn_com

        as 网管网www_bitscn_com

        insert into dbo.PublishLastRec_SQL(modiid,SignalGUID,AreaNo,SignalNote,AreaNote,PublishRoadStatus,PublishTime,IsExec) 中国网管联盟bitsCN.com

        select '1',SignalGUID,AreaNo,SignalNote,AreaNote,PublishRoadStatus,PublishTime,'0' from inserted

网管bitscn_com

        create trigger trg_PUBLISHLASTREC_update on PUBLISHLASTREC for update

网管下载dl.bitscn.com

        as 网管网www.bitscn.com

        insert into dbo.PublishLastRec_SQL(modiid,SignalGUID,AreaNo,SignalNote,AreaNote,PublishRoadStatus,PublishTime,IsExec) 网管u家www.bitscn.net

        select '3',SignalGUID,AreaNo,SignalNote,AreaNote,PublishRoadStatus,PublishTime,'0' from inserted 中国网管论坛bbs.bitsCN.com

        create trigger trg_PUBLISHLASTREC_delete on PUBLISHLASTREC for delete

网管下载dl.bitscn.com

        as

        insert into dbo.PublishLastRec_SQL(modiid,SignalGUID,AreaNo,SignalNote,AreaNote,PublishRoadStatus,PublishTime,IsExec) 网管联盟bitsCN@com

        select '2',SignalGUID,AreaNo,SignalNote,AreaNote,PublishRoadStatus,PublishTime,'0' from deleted