topic Re: Compression to SQL problems in Data Management Questions https://community.esri.com/t5/data-management-questions/compression-to-sql-problems/m-p/448698#M25664 <HTML><HEAD></HEAD><BODY><SPAN>CEI_gis, </SPAN><BR /><BR /><SPAN>Individual edits will appear in the base table in three situations:</SPAN><BR /><SPAN>- when the edits are common to all versions (reconciled and posted between all versions) and a compress is executed.</SPAN><BR /><SPAN>- if you are using the option to 'move edits to base' when you register your data as versioned and you save your edits </SPAN><STRONG style="text-decoration: underline;">in the Default version</STRONG><SPAN>.</SPAN><BR /><SPAN>- you use non-versioned editing.</SPAN><BR /><BR /><SPAN>My best guess based on your description is that you have edits that are not showing up in all of your versions. This is normal for most geodatabases, unless you are attempting to edit your tables directly with SQL there is likely nothing to worry about.</SPAN><BR /><BR /><SPAN>Versioning:</SPAN><BR /><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00270000000r000000.htm">http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00270000000r000000.htm</A><BR /><BR /><SPAN>Here is some doc on deciding how to register as versioned:</SPAN><BR /><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Deciding_how_to_register_data/002700000005000000/">http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Deciding_how_to_register_data/002700000005000000/</A><BR /><BR /><SPAN>Compress doc:</SPAN><BR /><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00290000005v000000.htm">http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00290000005v000000.htm</A><BR /><BR /><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/The_compress_operation_and_geodatabases/00270000001v000000/">http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/The_compress_operation_and_geodatabases/00270000001v000000/</A><BR /><BR /><SPAN>If you have further questions it is likely best to contact Esri Technical Support and they can give you more info.</SPAN><BR /><BR /><SPAN>Hope this helps,</SPAN></BODY></HTML> Fri, 29 Apr 2011 14:24:45 GMT RussellBrennan 2011-04-29T14:24:45Z Compression to SQL problems https://community.esri.com/t5/data-management-questions/compression-to-sql-problems/m-p/448696#M25662 <HTML><HEAD></HEAD><BODY><SPAN>Having issues with .sde compression showing up in the SQL tables.&nbsp; The project spanned 20 weeks.&nbsp; Each week new data was added and compressed in ArcMap.&nbsp; Weeks 1-17 appeared in SQL immediately upon compression.&nbsp; Weeks 18-20 have yet to show up.&nbsp; I am at a loss as to what exactly has happened that SQL is no longer receiving the .sde compression updates.&nbsp; Advice/Ideas?</SPAN></BODY></HTML> Tue, 12 Apr 2011 18:19:16 GMT https://community.esri.com/t5/data-management-questions/compression-to-sql-problems/m-p/448696#M25662 Anonymous User 2011-04-12T18:19:16Z Re: Compression to SQL problems https://community.esri.com/t5/data-management-questions/compression-to-sql-problems/m-p/448697#M25663 <HTML><HEAD></HEAD><BODY><SPAN>Are you compressing all the way to "State 0"?&nbsp; Sometimes existing connections or orphaned states can prevent edits from moving to the base tables.</SPAN><BR /><BR /><SPAN>Are you still having this issue?</SPAN></BODY></HTML> Thu, 28 Apr 2011 21:55:10 GMT https://community.esri.com/t5/data-management-questions/compression-to-sql-problems/m-p/448697#M25663 KenGalliher1 2011-04-28T21:55:10Z Re: Compression to SQL problems https://community.esri.com/t5/data-management-questions/compression-to-sql-problems/m-p/448698#M25664 <HTML><HEAD></HEAD><BODY><SPAN>CEI_gis, </SPAN><BR /><BR /><SPAN>Individual edits will appear in the base table in three situations:</SPAN><BR /><SPAN>- when the edits are common to all versions (reconciled and posted between all versions) and a compress is executed.</SPAN><BR /><SPAN>- if you are using the option to 'move edits to base' when you register your data as versioned and you save your edits </SPAN><STRONG style="text-decoration: underline;">in the Default version</STRONG><SPAN>.</SPAN><BR /><SPAN>- you use non-versioned editing.</SPAN><BR /><BR /><SPAN>My best guess based on your description is that you have edits that are not showing up in all of your versions. This is normal for most geodatabases, unless you are attempting to edit your tables directly with SQL there is likely nothing to worry about.</SPAN><BR /><BR /><SPAN>Versioning:</SPAN><BR /><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00270000000r000000.htm">http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00270000000r000000.htm</A><BR /><BR /><SPAN>Here is some doc on deciding how to register as versioned:</SPAN><BR /><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Deciding_how_to_register_data/002700000005000000/">http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Deciding_how_to_register_data/002700000005000000/</A><BR /><BR /><SPAN>Compress doc:</SPAN><BR /><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00290000005v000000.htm">http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00290000005v000000.htm</A><BR /><BR /><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/The_compress_operation_and_geodatabases/00270000001v000000/">http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/The_compress_operation_and_geodatabases/00270000001v000000/</A><BR /><BR /><SPAN>If you have further questions it is likely best to contact Esri Technical Support and they can give you more info.</SPAN><BR /><BR /><SPAN>Hope this helps,</SPAN></BODY></HTML> Fri, 29 Apr 2011 14:24:45 GMT https://community.esri.com/t5/data-management-questions/compression-to-sql-problems/m-p/448698#M25664 RussellBrennan 2011-04-29T14:24:45Z