Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
oracle snapshot without any change tracking RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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?

     

    Thanks 

    Tuesday, March 23, 2010 5:26 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    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