From time to time you may need to change the name of a Designer database or even copy the entire database to another location, perhaps to create a new testing environment or as part of a hardware upgrade.
Ideally you would reconcile, post, and delete all existing designs before beginning the migration. For occasions when some designs must remain outstanding during a migration, ArcFM and Designer provide two data source wizards that together can repoint existing designs to the new data location.
As always before making any major database change, back up the database (and in this case the MM_WMS_DESIGNS table in particular).
- ArcFM Data Source Wizard
- Changes the data source for Stored Display layers, including Stored Displays associated with particular existing designs. If this tool is not run, any designs that have their own Stored Displays will upon opening display red exclamation marks in the Table of Contents Display tab, and will fail to display the missing data on the map.
- Launch in ArcCatalog by right-clicking the database connection and choosing ArcFM Data Source Wizard.
- Workflow Manager Data Source Wizard
- Changes the data source for the design workspaces. If this tool is not run, any designs that have their own Stored Displays may display error messages indicating that the workspace was not found.
- Launch from the ArcFM installation folder, under ArcFM Solution\Bin\ WorkflowManagerDataSourceWizard.exe.
During each of these two processes you will browse to the new data source. This should be the source of the business data (electric/gas/water/fiber/etc.), not the process framework data.
When migrating a Designer database, run both wizards, starting with the ArcFM Data Source Wizard. When migrating an ArcFM-only database, you will only need to run the ArcFM Data Source wizard because sessions do not save workspace information.