topic Re: Using SDE views after upgrade in Data Management Questions https://community.esri.com/t5/data-management-questions/using-sde-views-after-upgrade/m-p/116410#M6646 <HTML><HEAD></HEAD><BODY><SPAN>It should (if it was working before upgrade), though generally speaking, it might</SPAN><BR /><SPAN>be better practice to drop and regenerate views with each ArcGIS upgrade.</SPAN><BR /><BR /><SPAN>Keep in mind that 'sdetable -o create view' was originally designed to function </SPAN><BR /><SPAN>with SDEBINARY and/or SDELOB storage geometry columns; best practice for</SPAN><BR /><SPAN>ST_GEOMETRY and other native geometry type is to use SQL to define the view,</SPAN><BR /><SPAN>then register the result with 'sdelayer -o register' (Note: the spatial reference</SPAN><BR /><SPAN>[-R] parameter is *not* optional at 10.1) or use the 10.1 Register with Geodatabase</SPAN><BR /><SPAN>tool.</SPAN><BR /><BR /><SPAN>- V</SPAN></BODY></HTML> Tue, 11 Dec 2012 15:07:11 GMT VinceAngelo 2012-12-11T15:07:11Z Using SDE views after upgrade https://community.esri.com/t5/data-management-questions/using-sde-views-after-upgrade/m-p/116409#M6645 <HTML><HEAD></HEAD><BODY><SPAN>I have an sde view created using the sdetable command in a SQL ArcSDE 10.0 database.&nbsp; If I upgrade the database to 10.1, will the view still hold?</SPAN></BODY></HTML> Fri, 07 Dec 2012 12:31:16 GMT https://community.esri.com/t5/data-management-questions/using-sde-views-after-upgrade/m-p/116409#M6645 SachinChand 2012-12-07T12:31:16Z Re: Using SDE views after upgrade https://community.esri.com/t5/data-management-questions/using-sde-views-after-upgrade/m-p/116410#M6646 <HTML><HEAD></HEAD><BODY><SPAN>It should (if it was working before upgrade), though generally speaking, it might</SPAN><BR /><SPAN>be better practice to drop and regenerate views with each ArcGIS upgrade.</SPAN><BR /><BR /><SPAN>Keep in mind that 'sdetable -o create view' was originally designed to function </SPAN><BR /><SPAN>with SDEBINARY and/or SDELOB storage geometry columns; best practice for</SPAN><BR /><SPAN>ST_GEOMETRY and other native geometry type is to use SQL to define the view,</SPAN><BR /><SPAN>then register the result with 'sdelayer -o register' (Note: the spatial reference</SPAN><BR /><SPAN>[-R] parameter is *not* optional at 10.1) or use the 10.1 Register with Geodatabase</SPAN><BR /><SPAN>tool.</SPAN><BR /><BR /><SPAN>- V</SPAN></BODY></HTML> Tue, 11 Dec 2012 15:07:11 GMT https://community.esri.com/t5/data-management-questions/using-sde-views-after-upgrade/m-p/116410#M6646 VinceAngelo 2012-12-11T15:07:11Z