SDE for SQL Server Express 

Two days

Author: Bruce Kessler

ArcGIS Version: 10

Printed Materials: Color and larger fonts for both lecture and exercise

Overview

This course covers the reasoning for using SQL Server Express and SDE in ArcGIS Desktop as well as practical installations, use and maintenance of a GeoDatabase within this environment. This uses the free software that comes with an ArcEditor or ArcInfo license. You will install SQL Server Express, create an SDE GeoDatabase, edit and maintain your data. You will work with non-versioned and versioned data using topology editing tools. There is testing of multiple replication processes that help you decide how to distribute your data across your organization, then testing of editing replications in a networked environment. Finally, this class explores the usefulness of archiving. This class is designed for users to set up this relatively complex environment using the classroom machine. If you make a mistake, the machine can be ghosted back to original environment. Under limited circustances this class can be taught on users machines, but it is designed to be taught using Kessler GIS computers.

Audience

This course is for advanced ArcGIS Desktop users wanting to capitalize upon using SDE without having to purchase an Enterprise license and a higher level DBMS. This class is not for users having only ArcView licensing.

Prerequisites and recommendations

Participants should have strong skills with ArcMap and ArcCatalog, understand some database design issues, understand topology, and be able to edit feature data skillfully.

 “Good presentation of information. Bruce's style keeps students interested." Shawn Glorio HDR, Inc.

™