What do we need to do to allow an agency admin to publish to CAT/Test using CATSQL Geodatabase as its source data. Then pass on to us a service definition that I can then publish to Production using ProductionSQL Geodatabase as its data source.
Are both databases SQL Server databases? Is CATSQL and ProductionSQL just different names for SQL Server databases?
Yes they both are SQL server databases- CATSQL is the testing and Production is a production SQL database
System Aliases for everyone.... System aliases to UNC paths for connection files, system alias on databases, registered connections in server, map services, application configurations...
Update stuff and have network admins transfer system aliases to the updated environment.