Abstract

Multiple to Single SDE Geodatabase Migration: Trials, Tribulations, and Successes
Track: Database Design and Management
Authors: Michelle Boivin

For 10 years, City of Fort Worth's GIS was a multiple geodatabase model that, as needs increased and ArcGIS technology morphed quickly became archaic and inefficient. With the increasing need for data availability, analysis, web viewing, and mobile field applications, came the need for a stream-lined functional geodatabase. Through data, user, and system architecture review, the city moved to a single database model making process automation easier and data & user management cleaner. To name a few successes, data was enhanced and almost all automated jobs moved from .Net, et.al. to Python. Cross-platform opportunities leveraged Active Directory groups and Database Roles to consolidate our approach to security rather than individual accounts. The journey was long and tedious, but the outcome was successful and extremely beneficial to the users as well as the public community. Every heartache we overcame is a heartache another entity will hopefully not have to go through.