Updating from arcsde to arcserver
Commonly used roles in an enterprise geodatabase include viewer, editor, etc.
As the names of these roles imply, one user group might be limited to read-only access to data while another group might be allowed to both read and edit the data.
While the DBO user is the person who administers the database at the SQL Server level (e.g., creating new users and roles), the SDE user is the person who administers the database within Arc GIS (e.g., updating database statistics and compressing the database).
Esri's documentation includes a page that discusses the pros and cons of each [
If, on the other hand, those two roles are filled by different people, then having the SDE user own the geodatabase is probably more advisable.In this course, we're going to work with a DBO-owned geodatabase.In the next section, you will be back working, via your Remote Desktop Connection, on your instance of the Amazon Machine Image (AMI) that holds our enterprise geodatabase, etc.Before diving into enterprise geodatabase concepts, it's important to understand some basics of working with SQL Server, the DBMS that we'll be using on our Amazon cloud instances. A login allows someone to authenticate with SQL Server and answers the question, "Who is connecting?" Access to an individual database (of which there could be several for a given SQL Server instance) is granted through .