I just started a new job and we have about 20 different clients. Each client has their own database with totally different schemas. I'm trying to combine all of the schemas into a blank database that covers everything with data in it. I have my first version (asset_v1.1).
It's very messy getting them 'migrated' into each database with all of the attributes coming along. Once they are moved I know they are at least good locked down with new subtypes and domains. The problem I'm running into is older employees are wanting to add or take away attribution. I'm now on version 1.4 of it and don't want to keep loading data for 20 databases with several feature classes within those. Basically I want to know if there's a way to take a database (1.4) and be able to add a field in a feature class and copy it to the new one (1.5) without having to load each feature and appending the data?
The end result I want every client to have the exact same database format. Some of our techs work for a client for a couple months then don't know where anything is in another clients database. Also having the same databases, I'm able to run scripts and update them much easier than customizing each one. Right now they're File Geodatabases, with hopes of getting everyone on SDE. Everything needs to be cleaned up before that would happen.