topic ArcGIS Desktop and SQL SMS not seeing the same values in Data Management Questions

ArcGIS Desktop and SQL SMS not seeing the same values

WestervilleGIS — Fri, 21 Feb 2014 15:51:33 GMT

I have 2 Enterprise Databases

Database 1 is a replica (1 way) to Database 2
I go in and make changes (attribute updates) to Database 1. Save the edits and synchronize the databases.
I load in the data from Database 2 to make sure that the changes are there. And they are present.

Now I switch over to SQL Server Mgmt Studio and query Database 1 OR Database 2 and the updates are not present.

Any Ideas?

10.1 database
SQL 2008

Re: ArcGIS Desktop and SQL SMS not seeing the same values

AsrujitSengupta — Fri, 21 Feb 2014 17:42:12 GMT

Courtney,

Reconcile/Post all the versions(if you have any) and then COMPRESS the sde geodatabase. This should reflect the changes in the tables at the database end.

HowTo: Compress a versioned database to state 0:
http://support.esri.com/en/knowledgebase/techarticles/detail/29160

http://esriaustraliatechblog.wordpress.com/2012/10/08/compressing-the-arcsde-geodatabase/

Regards,

Re: ArcGIS Desktop and SQL SMS not seeing the same values

MarcoBoeringa — Fri, 21 Feb 2014 19:26:20 GMT

And while you're on it, you may as well consider reading some of the links regarding versioning and data management in a ESRI Geodatabase that I pointed out in this post in another thread, so as to really start understanding it.

Especially the 2004 ESRI Versioning Whitepaper linked there is highly recommended reading, despite it's age.