topic Copy FC and Tables from SDE to regular SQL server 2014 in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/copy-fc-and-tables-from-sde-to-regular-sql-server/m-p/789878#M2067 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I am doing some tests. I was able to copy SDE FCs and Tables into a regular SQL server 2014 database using ArcCatalog.&nbsp; Now I can see these FC in SQL Server using ArcCatalog. It keeps the shape part. Also I was able to create an SDE view in SQL Server.</P><P></P><P>I can not copy Feature Datasets.</P><P></P><P></P><P>Then I copied back the FC created in SQL Server to ArcSDE and it seems ok.</P><P></P><P>I was wondering if I can use a regular SQL server database as a intermediate GIS storage for processing and then copy the final result into an SDE instance.</P><P></P><P>Any pros and cons.</P><P></P><P>Thanks</P></BODY></HTML> Tue, 15 Oct 2019 14:36:15 GMT JoseSanchez 2019-10-15T14:36:15Z Copy FC and Tables from SDE to regular SQL server 2014 https://community.esri.com/t5/geodatabase-questions/copy-fc-and-tables-from-sde-to-regular-sql-server/m-p/789878#M2067 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I am doing some tests. I was able to copy SDE FCs and Tables into a regular SQL server 2014 database using ArcCatalog.&nbsp; Now I can see these FC in SQL Server using ArcCatalog. It keeps the shape part. Also I was able to create an SDE view in SQL Server.</P><P></P><P>I can not copy Feature Datasets.</P><P></P><P></P><P>Then I copied back the FC created in SQL Server to ArcSDE and it seems ok.</P><P></P><P>I was wondering if I can use a regular SQL server database as a intermediate GIS storage for processing and then copy the final result into an SDE instance.</P><P></P><P>Any pros and cons.</P><P></P><P>Thanks</P></BODY></HTML> Tue, 15 Oct 2019 14:36:15 GMT https://community.esri.com/t5/geodatabase-questions/copy-fc-and-tables-from-sde-to-regular-sql-server/m-p/789878#M2067 JoseSanchez 2019-10-15T14:36:15Z