Masuk
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Sync between Oracle 11g & MS SQL Server

Pregunta Sync between Oracle 11g & MS SQL Server

  • 30 Juli 2012 7:04
     
     
    Masuk untuk Memilih
    0

    Hi - I want to sync tables between Oracle 11g and SQL Server 2005/8.  Do we have any way of doing this using the Sync Framework4 and are there any live examples that I can refer to?  Thanks in advance...Murali


     

Semua Balasan

  • 30 Juli 2012 13:55
    Moderator
     
     
    Masuk untuk Memilih
    0

    first, there is no sync framework 4.

    what was supposed to be v4 is now known as the Sync Toolkit.

    The toolkit was designed to target new client platforms that cannot install the full Sync Framework SDK such as Silverlight, Windows Phone, iPhone, HTML5, etc...

    it is not a version upgrade to v2.1. the toolkit actually requires 2.1 on the server.

    so to answer your question, if you want to sync Oracle with SQL Server using the toolkit, you will have to write your own provider for Oracle.

    You can also choose to simply use Sync Fx 2.1. Have a look at this sample: Database Sync: Oracle and SQL Compact 2-Tier

    just replace the SqlCeSyncProvider with SqlSyncProvider.