Answered by:
Error while synchronization- invalid object name scope_info

Question
-
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
singhhomeWednesday, May 26, 2010 4:29 PM
Answers
-
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.
- Proposed as answer by Ann Tang [MSFT]Microsoft employee Wednesday, May 26, 2010 5:59 PM
- Marked as answer by singhhome Friday, May 28, 2010 3:15 PM
Wednesday, May 26, 2010 5:19 PMAnswerer
All replies
-
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.
- Proposed as answer by Ann Tang [MSFT]Microsoft employee Wednesday, May 26, 2010 5:59 PM
- Marked as answer by singhhome Friday, May 28, 2010 3:15 PM
Wednesday, May 26, 2010 5:19 PMAnswerer -
Is there a way I can control/restrict the Tables/SPs it creates. I need to have only upload Sync.
Regards
singhhomeWednesday, May 26, 2010 6:43 PM -
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 PMAnswerer -
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?
/
mysorianFriday, July 30, 2010 3:31 AM -
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- Edited by Jayaram Krishnaswamy Saturday, July 31, 2010 8:34 PM quoted parts
Saturday, July 31, 2010 8:33 PM