oracle snapshot without any change tracking RRS feed

  • Question

  • Hi,

    what I need is just a snapshot of multiple oracle tables to sqlce.  I don't have any access to be able to create triggers or additional tables for change tracking on the server.  I want to use the sync framework for it's batching and statistics functions.  I've poured through the documentations and example codes but those codes apply to databases that has change tracking and synchronization.  How do I go about just getting a snapshot of my oracle tables with the schema and indexes into sqlce using the sync framework?



    Tuesday, March 23, 2010 5:26 PM

All replies

  • not sure if this will work cause i don't have Oracle to test, but you can try this:

    if you have SQL Server, copy the Oracle schema to temporary database in SQLServer.

    fire up Visual Studio, create a new project (console or winform)

    Add new item and select Local Database Cache

    Configure the sync between SQLServer and SQLCE first and for each table you want a snapshot, make sure to select under Client Configuration->Data to Download :Entire Table Each time. This configures snapshot sync.

    Then the Local Database Cache designer generates the code.

    Modify the connection string pointing to SQL Server and point it to Oracle.

    Test the sync.


    Wednesday, March 24, 2010 9:28 AM