Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Error while synchronization- invalid object name scope_info RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Is it necessary to create scop_info table in source sql server? My source sql server is read only and i can't create new tables/SPs on that server.

    Regards

     

    singhhome
    Wednesday, May 26, 2010 4:29 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Metadata information needs to be recorded in the source and destnation databases for Database Sync.

    Sync framework needs to track changes in the database, enumerate changes since last sync etc. Relevant information has to be persisted in the sync metadata tables, generated or used by triggers and stored procs and consumed by Sync framework code.

    Wednesday, May 26, 2010 5:19 PM
    Answerer

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Metadata information needs to be recorded in the source and destnation databases for Database Sync.

    Sync framework needs to track changes in the database, enumerate changes since last sync etc. Relevant information has to be persisted in the sync metadata tables, generated or used by triggers and stored procs and consumed by Sync framework code.

    Wednesday, May 26, 2010 5:19 PM
    Answerer
  • Question
    Sign in to vote
    0
    Sign in to vote

    Is there a way I can control/restrict the Tables/SPs it creates.   I need to have only upload Sync.

    Regards

    singhhome
    Wednesday, May 26, 2010 6:43 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    You can take a look at the sync components required for a database sync at http://msdn.microsoft.com/en-us/library/dd918682(v=SQL.105).aspx, there are not many things you can trim for sync, except a few local apply change related SPs.

     

    Friday, May 28, 2010 5:16 PM
    Answerer
  • Question
    Sign in to vote
    0
    Sign in to vote

    In this video [   http://msdn.microsoft.com/en-us/windowsazure/ee960244.aspx   ]the code for creating a project to synchronize does not consider the scope_info part. Scope-info is created when you try to sync the first time. In the video presentation does the author already has these tables so that he just sync's the two databases?

     

    /

    mysorian
    Friday, July 30, 2010 3:31 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Disregard the question. The introduction to the video in another location says this,

    "<quote>and executes  synchronization between a SQL Server and SQL Azure database that had previously been created using the "SQL Azure Data Sync Tool for SQL Server"</quote>

     

    To start with the video presenter works with an existing pair of local data and data on SQL Azure created from running synchronization. So he already had the scope_info to start with.

     

    mysorian
    Saturday, July 31, 2010 8:33 PM