Setting up the aeronautical production database (Aeronautical Solution)

The production database is the primary database that contains the geographic data. That data can be used directly or to create and maintain the charts, maps, and cells for production. It is built from a valid ArcGIS for Aviation: Charting data model.

Importing the XML schema

You need to create an empty geodatabase in ArcCatalog to be able to import the schema for data or chart production.

Steps:

1. Start ArcCatalog.
2. If necessary, create an empty ArcSDE geodatabase on a database server or one that is licensed through ArcGIS for Server.
3. Do one of the following in the Catalog Tree window:
   • Expand Database Connections if using a geodatabase in Oracle, enterprise geodatabase in SQL Server, or other enterprise geodatabase.
   • Expand Database Servers if using an ArcSDE geodatabase for SQL Server Express licensed for ArcGIS for Desktop.
4. Right-click the database and click Import > XML Workspace Document.

   The Import XML Workspace Document dialog box appears.

5. Choose the Schema Only option.
6. Browse to <Install directory>\Program Files\ArcGIS\EsriAeronautical\Desktop10.1\Schemas and open the AIS_GX_WGS84.xml source file to import.
7. Click Next.
8. Review the summary.
9. Click Finish.

Versioning and archiving on the production database

You can choose to enable geodatabase archiving on a production database. Geodatabase archiving is ArcGIS functionality to maintain an archive of all changes to a geodatabase. Through archiving, it is possible to view data as it existed at any point in the past. Archiving must be enabled for the Change Reporter tool to retrieve changes made between specified dates.

Steps:

1. Select all feature classes, attributed relationships, and tables in the geodatabase, right-click, then click Manage > Register as Versioned.
2. Select all feature classes, right-click, then click Enable Archiving.

   Once the appropriate schema has been applied, you can configure the production database.