topic Re: Detect When a Feature Class Was Replicated in Data Management Questions

Detect When a Feature Class Was Replicated

RobertPincus — Thu, 06 Jan 2011 14:37:56 GMT

How can I programmatically detect when a feature class was replicated from a maintenance database to a production database? I tried using the modified_date in the sys.objects table in the production database, but the date never changed. The databases are SQL Server 2008.

Thanks,
Robert

Re: Detect When a Feature Class Was Replicated

HeatherMcCracken — Mon, 10 Jan 2011 15:38:48 GMT

Are you using Geodatabase Replication, or SqlServer (Database) replication?
-Heather

Re: Detect When a Feature Class Was Replicated

RobertPincus — Tue, 11 Jan 2011 13:51:45 GMT

Geodatabase Replication

Re: Detect When a Feature Class Was Replicated

RobertHu — Tue, 11 Jan 2011 19:35:12 GMT

This query returns the date/time FCs being synced in last 10 days,

SELECT
    GPReplicaDataset.value('DatasetName[1]', 'nvarchar(max)') AS 'Feature Class',
    CAST(replicalog.LogDate AS smalldatetime) AS 'Sync Time'
FROM
    sde.GDB_ITEMS AS items
        INNER JOIN sde.GDB_ITEMTYPES AS itemtypes
        ON items.Type = itemtypes.UUID
        INNER JOIN sde.GDB_REPLICALOG AS replicalog
        On items.ObjectID = replicalog.ReplicaID
CROSS APPLY
    items.Definition.nodes
        ('/GPReplica/GPReplicaDescription/GPReplicaDatasets/GPReplicaDataset')
        AS GPReplicaDatasets(GPReplicaDataset)
WHERE
    itemtypes.Name = 'Replica'
    AND ( GETDATE() - replicalog.LogDate ) < 10
ORDER BY 'Feature Class', 'Sync Time' ;

GO

Re: Detect When a Feature Class Was Replicated

HeatherMcCracken — Tue, 11 Jan 2011 19:40:02 GMT

Take a look at IReplica2.log

http://help.arcgis.com/en/sdk/10.0/arcobjects_net/componenthelp/index.html#/Log_Property/00250000078q000000/

This will tell you when a replica last received changes, if you know which replica you data participates in, this will be enough for you to know when it was last updated (if changes sent to that fc as part of the sync). If not, you'll just need to query the IReplicaDatasets property of the replica to see if you data participates in which replica.

Thinking this will give you what you need?
Thanks,
Heather

Re: Detect When a Feature Class Was Replicated

RobertPincus — Wed, 12 Jan 2011 17:46:31 GMT

I'll look into it ASAP