Importing data

Import data exported from an AppScan Source database into AppScan Enterprise.

Important: Before importing data, ensure the exported data directory and contents is available and visible to the import system. If data is being exported and imported on different physical systems, copy the entire export data directory and contents to the import system.

Define the environment variable transfer_staging_dir to point to the location of the exported data directory.
- Windows:
```
set transfer_staging_dir="<export data location>"
```
- Linux:
```
export transfer_staging_dir="<export data location>"
```
Define the appscan_source_shared_data environment variable to point to the location of the migration utility.
- Windows:
```
set appscan_source_shared_data=<<path>\migration_util_win>
```
- Linux:
```
 export appscan_source_shared_data=<<path>/migration_util_linux>
```
From the command line, navigate to the location of the migration utility.
Run the utility with appropriate parameters to import data into AppScan Enterprise. Ensure that you list the import parameters in the order shown.
- Windows:
```
DBManager.exe --import --user=<ASE userName> --pwd=<ASE password> --server=<ASE serverURL>
```
- Linux:
```
./dbmanager --import --user=<ASE userName> --pwd=<ASE password> --server=<ASE serverURL>
```
Note: For help using import commands, run:
- Windows:
```
DBManager.exe --import --help
```
- Linux:
```
./dbmanager --import --help
```

Migration utility import parameters


Parameter	Value	Required?
`--user`	The AppScan Enterprise user name (administrator or user with permission to create shared data)	Yes
`--pwd`	The password of the specified user	Yes
`--server`	The server location of AppScan Enterprise	Yes

Troubleshooting import

If you experience any issues while importing data, refer to the dbmanager_exceptions.log file in the migration utility installation path. The default locations are:

Windows:

C:\Program Files (x86)\IBM\AppScanSource\migration_util_win\logs\dbmanager_exceptions.log

Linux:

/opt/ibm/appscansource/migration_util_linux/logs/dbmanager_exceptions.log