כניסה
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Sync between Oracle 11g & MS SQL Server

Unanswered Sync between Oracle 11g & MS SQL Server

  • יום שני 30 יולי 2012 07:04
     
     
    היכנס כדי להצביע
    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


     

כל התגובות

  • יום שני 30 יולי 2012 13:55
    מנחה דיון
     
     
    היכנס כדי להצביע
    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.