Latest Contributions by mpboyle

This is my first go around with gdb replication and am looking to create a 1-way replica from a sde gdb to either another sde gdb or a file gdb.  I was hoping to get an idea of the best practices and workflows for keeping the two gdbs in sync? My assumption is you start with the Create Replica tool in order to replica data from parent to child, is that right? After that is done, I have a few questions about workflow and best practices... 1) How do you add a feature class to the child gdb after the replication process is in effect? 2) If a feature class is deleted from the parent gdb, how do you delete the feature class in the child?...do you simply delete it through ArcCatalog? 3) If a field is added or removed in a feature class within the parent gdb, how do you send that change to the child gdb?...can it be automated or is it manual? 4) If a domain is added / altered / removed, how do you send those changes to the child?...can it be automated or is it manual? 5) What is a good 'routing' for syncing changes?  Do you first reconcile and post edits in the parent gdb, then sync changes?  Should some processes, like comparing schema be done first before syncing changes? I'm looking to get an idea of what workflows others use that have been successful, easy to manage, and keeps your data in sync. Thanks! ... View more

Our production enterprise system is currently 1 sde gdb (Sql Server 2014) with several (45 to be exact) datasets and 9 editable versions (based on department). The sheer number of datasets makes it a little cumbersome for users to find what they may be searching for. I was wondering if anyone has tried breaking down a large sde gdb into several smaller gdbs, perhaps 1 sde gdb per department?  If so, is there is a performance advantage of having 1 large sde gdb versus several smaller sde gdbs?  Is response time better for smaller gdb versus larger gdbs?  Would reducing the number of versions have a benefit on performance? I'm hoping to get some pros / cons of having 1 large sde gdb which is like a one-stop-shop for any GIS needs or several smaller sde gdbs meant for departmental needs. Thanks! ... View more

I'm wondering if anyone else out there has experienced a similar issue with 10.3.1 or if someone from Esri can duplicate my problem... I recently received a new machine and installed 10.3.1 on it and I seem to have an issue with feature classes not having the same SRID as the dataset they are contained within.  If I create a similar dataset with 10.3 and do the same steps, I don't have this problem. Below are some details of the issue: 1) Dataset Working103 = dataset created with ArcGIS 10.3.  SRID = 103045 (NAD 83 Iowa State Plane North 2011) 2) Dataset Working1031 = dataset created with ArcGIS 10.3.1.  SRID = 103045 (NAD 83 Iowa State Plane North 2011) Next, I created a simple point feature class within each dataset, and inserted 3 features within each feature class.  The feature class within the dataset created with 10.3 has the same SRID as the dataset, 103045.  The feature class within the dataset created with 10.3.1 has a SRID of 6463, which I can't seem to find browsing through Esri's list of coordinate systems, so I have no idea what it is. Feature class within dataset created with 10.3 has the correct SRID Feature class within dataset created with 10.3.1 doesn't have the same SRID as the dataset If I do a spatial intersect query within Sql Server on the 2 feature classes using a polygon feature class from our production gdb, where all feature classes have a SRID of 103045, the feature class with the correct SRID returns results, while the other does not. Spatial intersect query works with dataset created in 10.3 bc SRIDs match Spatial intersect query does NOT work with dataset created in 10.3.1 bc SRIDs do NOT match Has anyone else experienced this issue...? Is this a known bug...?  Is this specific to our use of SRID 103045...? ... View more

I'm wondering if it's possible to create a query within Sql Server that lists the users that have a lock on a feature class...?...something similar to what you'd see within the 'Locks' view of the Gdb Administration. I'm assuming this is stored within various 'sde_' tables and related through identifiers.  I'm hoping someone from Esri could point me in the right direction.  We aren't looking to alter any of the background 'sde_' tables, just looking to reproduce the query that generates such a list. Thanks! ... View more