What is the best practice to reapply a asset package.

02-28-2022 11:05 AM
New Contributor

We created a utility network from an asset package. Now we have a new asset package that we would like to load. I wanted to know what the steps are to apply this new asset package.  There is this link where it is mentioned that we would have to drop the geodatabase and recreate a new gdb.



The steps listed in the link suggest the following:

  1. Delete the UNM Enterprise Geodatabase via SQL Server Management Studio (i.e. in SQL Server Management Studio, right-click the database and click Delete).
  2. Create a brand-new Enterprise Geodatabase in SQL Server.
  3. Create a UNOWNER in the new Enterprise Geodatabase.
  4. Stage a Utility Network in the new Enterprise Geodatabase.
  5. Apply the revised Asset Package to the new Enterprise Geodatabase.

Is this best workflow?

3 Replies
Esri Contributor

Dropping and recreating the database is probably the quickest way but may not be feasible all the time, especially if DBAs are involved. I normally drop the UN topology, then drop UN dataset and related tables. And delete all domains (all through few lines of python code) and then stage and re-apply asset package as per your steps 4 and 5 above. 

New Contributor III

Sometimes I leave the UN feature dataset, in order to keep the service territory.  Deleting all of the domains is key however, otherwise they get duplicated with each re-apply of the asset package.  

Brian Colson, GISP
New Contributor III

We do this regularly during the UN development process for our clients.  We have scripted the exact workflow you described into a Jupyter notebook.  So the label of 'best' is subjective to your environment and needs, but it certainly works for us.