none
Database Synchronisation between ORACLE and SQL RRS feed

  • Question

  • Hello All,

    Can someone please advice me if it is achieveable to have database synchronisation between ORACLe and SQL using Msoft Sync Framework?

    I require both SQL and ORALCE to be updateable ends according to which synchronization should occur.

    If it is possible, can someone provide me stsp by step steps to set this up..?

    Thanks

    Thursday, December 31, 2009 9:35 AM

Answers

  • Hi,

    SQL CE indeed stands for SQL Server Compact Edition, it is just a very lightweight version of SQL Server.
    So since the Oracle sample is using the SqlCeSyncProvider class, you need to use (and configure) the SqlSyncProvider class.
     go look at the SynchronizationHelper.cs => ConfigureSqlSyncProvider method in the SQL-SQL example.

    You will need to spend some time to understand the samples, but what you want to do is possible with the samples given.

    I would advise not to use the example of syncguru.com, as these are based on the offline providers, which is a totally different model and do not support SQL Server as the client database. (ps: This site is also no longer up to date with the latest release.)

    From your posts in other forums what you need is to use the Collaboration (or Peer-to-Peer) providers as in the above examples. But you need to take the Oracle Provider form the first example and the SQL Provider from the second example and use them in your own Windows Service application that you need to develop.

    Are you comfortable with developing in C#? If not, then the Sync Framework is not your tool. If you are, then you are close to a solution, it just takes a few days to get into the framework and develop your solution.
    Wednesday, January 6, 2010 12:35 PM

All replies

  • Hi,

    It is possible. Check out syncguru.com they have a working sample there.
    Please mark the response as answers if it solves your question or vote as helpful if you find it helpful. http://thoughtorientedarchitecture.blogspot.com/
    • Proposed as answer by Haripraghash Tuesday, January 5, 2010 4:32 PM
    • Unproposed as answer by RubSay Wednesday, January 6, 2010 11:25 AM
    Tuesday, January 5, 2010 4:32 PM
  • There is now als a sample for Oracle and SQL CE:
    http://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=sync&ReleaseId=3761

    If you need to replace SQL CE with SQL Express, that should be possible see the other sample posted:
    http://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=sync&ReleaseId=3762
    • Proposed as answer by Rudi - Euricom Wednesday, January 6, 2010 12:35 PM
    Wednesday, January 6, 2010 9:00 AM
  • sorry...but what is SQL CE....?? what does CE stand for?

    OK looks like CE means Compac Edition. But i have SQL server 2005 Standard Edition.

    Can the synchronization still be achieved??
    Wednesday, January 6, 2010 10:04 AM
  • Hi Hari,

    I naviagted to link http://www.syncguru.com/projects/SyncServicesDemoBuilder.aspx Is it the right place i am looking at. I am still unable to understand anything out from here....????
    Wednesday, January 6, 2010 11:11 AM
  • Hi,

    SQL CE indeed stands for SQL Server Compact Edition, it is just a very lightweight version of SQL Server.
    So since the Oracle sample is using the SqlCeSyncProvider class, you need to use (and configure) the SqlSyncProvider class.
     go look at the SynchronizationHelper.cs => ConfigureSqlSyncProvider method in the SQL-SQL example.

    You will need to spend some time to understand the samples, but what you want to do is possible with the samples given.

    I would advise not to use the example of syncguru.com, as these are based on the offline providers, which is a totally different model and do not support SQL Server as the client database. (ps: This site is also no longer up to date with the latest release.)

    From your posts in other forums what you need is to use the Collaboration (or Peer-to-Peer) providers as in the above examples. But you need to take the Oracle Provider form the first example and the SQL Provider from the second example and use them in your own Windows Service application that you need to develop.

    Are you comfortable with developing in C#? If not, then the Sync Framework is not your tool. If you are, then you are close to a solution, it just takes a few days to get into the framework and develop your solution.
    Wednesday, January 6, 2010 12:35 PM
  • This simple question is whether it is possible to sync SQL Server and Oracle database using sync framework? And not the SQL CE.

    I have multiple instances of SQL Server and the centralized oracle server. I want to sync them up using the MS sync framework.

    Saturday, September 11, 2010 10:09 AM
  • as mentioned by Rudi, you should be able to replace SqlCeSyncProvider with the SqlSyncProvider in the sample Oracle to SqlCe synchronization(http://code.msdn.microsoft.com/sync/Release/ProjectReleases.aspx?ReleaseId=3761). Note that this sample has not been updated yet to the 2.1 release though.
    Saturday, September 11, 2010 2:28 PM
    Moderator