The ssadbcopy utility has the following known limitations:
You cannot use wildcards for the schema and table name.
You cannot migrate multiple databases (archive folders) at the same time. But you can migrate multiple databases at one time by running several ssadbccopy commands concurrently.
You cannot use FTP transfer mode from a Windows source to a Windows target. You can use the FTP transfer mode to a Unix target from a Unix or Windows source.
If the table structure in the source has changed, you must use the drop/create mode when you import the data in the target.
There are no run-time checkpoints. If the process fails, you must start the export and import from the beginning after you validate and fix the problem.
If the selected database, schema, or table has materialized views, the respective SCT files will be created in the local file system (mviewdir).
If the migration is performed at the schema or table level using the ssadbcopy utility, before migrating the database (from one Data Vault instance to the other), the SCT files of different tables should be present in only one storage type.
If the migration is performed at the table level using ssadbcopy utility, all the SCT files of that particular table should be present in only one storage system. SCT files of other tables can be present in other storage systems.