Sql Ce Replication information

  • Thread starter Thread starter Steve B.
  • Start date Start date
S

Steve B.

Hi,

I use Sql Ce 2.0 with merge replication.

Is there any way to determine which tables are concerned with a given
replication ?

I did not find any usefull information in INFORMATION_SCHEMA.*

Thanks,
Steve
 
I do not understand the structure of this table...

I have two replications in my application.
I want to know wich tables are replicated with repl1, and which with
repl2...

Steve
 
In sysmergepublications there are all publication of the database, to find
tables for a plublication join
sysmergepublications and sysmergearticles on pubid.
Marius
 
Ok, but this on the SQL Server 2000, not subscriber (sql ce).

I need to determine which tables are related to one replication ON the
device (because of some cache mecanims, I need clear objects related to one
table when the table is replicated)

Steve
 
Sql Server CE 2.0 supports only one subscription per database. So if a table
is replicated it is member of a single publication.
When replication is performed you can't control witch tables are replicated
(all tables in subscription will be replicated) so you should invalidate
cache for all tables involved in replication.

I don't know a method to determine what tables form a sql ce database are
member of a subscription but I think is safe to assume that tables that have
columns s_Generation and s_RowLineage are replicated.

Marius
 
Back
Top