SQL Server与Oracle的数据同步

        as

        select * from ORACLEDB..ROADSMS.PUBLISHLASTREC

        //ORACLEDB链接服务器名,ROADSMS为表空间名,PUBLISHLASTREC 为数据表名

        create trigger trg_PUBLISHLASTREC_insert on PUBLISHLASTREC for insert

        as

        insert into dbo.PublishLastRec_SQL(modiid,SignalGUID,AreaNo,SignalNote,AreaNote,PublishRoadStatus,PublishTime,IsExec)

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

        create trigger trg_PUBLISHLASTREC_update on PUBLISHLASTREC for update

        as

        insert into dbo.PublishLastRec_SQL(modiid,SignalGUID,AreaNo,SignalNote,AreaNote,PublishRoadStatus,PublishTime,IsExec)

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

        create trigger trg_PUBLISHLASTREC_delete on PUBLISHLASTREC for delete

        as

        insert into dbo.PublishLastRec_SQL(modiid,SignalGUID,AreaNo,SignalNote,AreaNote,PublishRoadStatus,PublishTime,IsExec)

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