This forum is closed. Thank you for your contributions.

Sign in

Microsoft.com

Microsoft

Remove From My Forums

Metadata storage whilst using DbSyncProvider

Question
0

Sign in to vote

After reading a blog (http://blogs.msdn.com/mahjayar/archive/2008/06/25/getting-started-with-dbsyncprovider-peer-to-peer-synchronization.aspx ) and MSDN docu, I've got the impression that using DbSyncProvider requires me to store the metadata of the synchronized tables in the same database. But in my business case, it's impossible to store the metadata in the same database. So my question is: Is it possible to store metadata in another database (and not in the same DB) whilst using DbSyncProvider class?

Thursday, April 22, 2010 12:25 PM

Answers

0

Sign in to vote
Hi Egon,

One option available is Linked Sql Server where you can issue distributed query. You will have to update your sync commands set for the dbsyncprovider accordingly. This option may however take some performance hit. The second link below will give you some tips and guidelines to keep performance in check.

http://msdn.microsoft.com/en-us/library/aa213778(SQL.80).aspx

http://www.sql-server-performance.com/tips/linked_server_p1.aspx

If you are ok with same database but different namespace(schema name) will address your concern then this would be better option.

Thanks

Jandeep
jandeepc
- Proposed as answer by Jandeep Wednesday, April 28, 2010 6:17 PM
- Marked as answer by Sid Singh [MSFT]Microsoft employee Thursday, May 27, 2010 12:30 AM
Monday, April 26, 2010 10:11 PM