sherriekubis

SDE with SQL Server

Discussion created by sherriekubis on Nov 28, 2016
Latest reply on Dec 2, 2016 by sherriekubis

SQL Server 2016 

SDE 10.5 

 

Our SDE prototype to migrate from Oracle is ramping up.   We have experience with SDE in Oracle, but not in SQL Server.  Because this pilot will continue for the next year, we are going with the latest and greatest versions.  I'm looking for best practices, suggestions, tips on using SDE in MS SQL.  

 

In Oracle, we have a master geodatabase and user-schema geodatabases in the same Oracle database.  We do versioned editing in the user-schema gdbs.  

 

Can anyone share their experience?  I'm just starting, getting the terminology down and a staging SQL instance and database up and running.  There is a lot to learn. 

 

Sherrie

Outcomes