To export data from the source Data Vault system, run the ssadbcopy command in the source system.
Before you begin, you want to verify how many rows the source TICKET table includes. You run a query to count the rows in the TICKET table. The TICKET table includes 30,000 rows. After you copy the data to the target Data Vault system, you plan to run the same query on the target to confirm that the partial data copy is successful.
The following figures shows an example of the query and the query results:
To export the data, run the following ssadbcopy command in the source system: