Online Documentation Source for the FED System

Exporting a table in AirFact format to the production AirFact table

  1. Connect to the AIRDATA_IMPORT database.
    1. Open SQL Server Management Studio (SSMS).
    2. Connect to database server VADER (IP: 129.82.109.167).
    3. Expand the Databases item in the Object Explorer pane.
    4. Locate the AIRDATA_IMPORT database.
  2. Right-click on the AIRDATA_IMPORT item and select Tasks --> Export Data... from the context menu to open the SQL Server Import and Export Wizard. Export the data to the production AirFact table
  3. Click Next > on the start page of the wizard, if shown. Import/Export Wizard Start page
  4. Complete the Choose a Data Source page of the wizard:
    1. Click the Data source: dropdown menu and select SQL Server Native Client 11.0.
    2. In the Server name: dropdown menu, type or select "VADER".
    3. Enter the appropriate credentials in the Authentication section.
    4. In the Database: dropdown menu, type or select "AIRDATA_IMPORT"
    5. Click the Next > button.
    Import/Export Wizard - Choose a Data Source
  5. Complete the Choose a Destination page of the wizard:
    1. Click the Destination: dropdown menu and select SQL Server Native Client 11.0.
    2. In the Server name: dropdown menu, type or select "VADER".
    3. Enter the appropriate credentials in the Authentication section.
    4. In the Database: dropdown menu, type or select "AIRDATA_CORE"
    5. Click the Next > button.
    Import/Export Wizard - Choose a Destination
  6. On the Specify Table Copy or Query page, check the Copy data from one or more tables or views button and then click Next >. Import/Export Wizard - Specify Table Copy or Query
  7. Complete the Select Source Tables and Views page of the wizard:
    1. Expand the wizard dialog enough so that you can clearly see the full table names in the Source column.
    2. Find the newly-created table (which must already be in AirFact format) in the Source column and check the box next to it.
    3. Click the Destination cell next to the selected table name and select the AirFact table from the in-cell dropdown menu.
    Import/Export Wizard - Select Source Tables and Views
  8. Click the Edit Mappings... button and verify that the source and destination fields are identical (with the possible exception of the ROWNUM field in the source table which can be safely <ignored>), then click "OK" to close the Column Mappings dialog. Finally, click Next > on the Select Source Tables and Views dialog. Import/Export Wizard - Edit Mappings
  9. On the Save and Run Package page, check the Run immediately box and then click Next. Import/Export Wizard - Save or Run Package
  10. On the Complete the Wizard page, double-check your choices and then click the Finish button. Import/Export Wizard - Complete the Wizard
  11. The Performing Operation... dialog will open and the table will be copied to the production AirFact table.
    Depending on the size of the table being copied, the operation could take a few seconds to several hours. Note the <N> rows transferred message in the Status field of the Copying to AirFact item - it will show how many rows have been copied at any given time in order to give you an idea of how far along the transfer process is.