Post reply

ORACLE WITH MSSQL TALBE (Need Help) without link server

  • October 18, 2016 at 2:19 am

    #322123

    hey

    i have db in mssql and i want to select. update insert to oracle table.

    can i create table,view or somthing in mssql (i have odbc to oracle) ? like mirror of oracle table.

    when i update in table mssql db , fact ,the chage will be in oracle

    thanks

  • October 18, 2016 at 1:20 pm

    #1907251

    liorvikel (10/18/2016)

    hey

    i have db in mssql and i want to select. update insert to oracle table.

    can i create table,view or somthing in mssql (i have odbc to oracle) ? like mirror of oracle table.

    when i update in table mssql db , fact ,the chage will be in oracle

    thanks

    Without using linked servers and having something like mirroring of tables, the only option I can think of would be replication. Probably others but you could look into Golden Gate for replication.

    Sue

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply