locked
SQL server to Oracle RRS feed

  • Question

  •  

    Is it possible to do synchronization between SQL server and Oracle using the Sync framework? If not, any other microsoft framework that I could use?  thanks for any advice
    Wednesday, January 7, 2009 12:27 AM

Answers

  • Absolutely.  Sync Framework would allow you to do this.  I assume you just have two databases?  One is SQL Server and the other is Oracle? 

     

    The bad news is that I do not know of any samples that show this exact scenario for Oracle.

     

    If you look at the SQL Express Peer provider sample included with Sync Framework it might give you a start:

     

    C:\Program Files\Microsoft SDKs\Microsoft Sync Framework\v1.0\Runtime\ADO.NET\V2.0\Samples

     

    Also, take a look at the sample from the Synchronizer blog it might also give you some help on how to set up change tracking in an Oracle database.

     

    http://blogs.msdn.com/synchronizer/archive/2007/03/09/demo-v-offlineapplication-oracle-backend.aspx

     

    Liam

     

    Wednesday, January 7, 2009 4:37 PM

All replies

  • Absolutely.  Sync Framework would allow you to do this.  I assume you just have two databases?  One is SQL Server and the other is Oracle? 

     

    The bad news is that I do not know of any samples that show this exact scenario for Oracle.

     

    If you look at the SQL Express Peer provider sample included with Sync Framework it might give you a start:

     

    C:\Program Files\Microsoft SDKs\Microsoft Sync Framework\v1.0\Runtime\ADO.NET\V2.0\Samples

     

    Also, take a look at the sample from the Synchronizer blog it might also give you some help on how to set up change tracking in an Oracle database.

     

    http://blogs.msdn.com/synchronizer/archive/2007/03/09/demo-v-offlineapplication-oracle-backend.aspx

     

    Liam

     

    Wednesday, January 7, 2009 4:37 PM
  • thanks for your reply Smile

     

    Monday, January 12, 2009 9:07 PM