Hi Trevor
If you are just restoring your Pilot DB to Test, you need to restore the SQL DB.
Then you need to also backup and restore the schema holder.
This second step is the one that has been missed.
commands to lookup are Probkup and Prorest (navigate to epicor905\db\newdb and you will find a restore batch as a reference)

You then don't need to use the DMT to do any data manipulation as you are restoring the DB with data in it.

However for reference DMT can be scripted with documentation available on EpicWeb. The current version does not export data, as you do this via a BAQ if required.

An update. After muddling through this for days, Stephen is exactly right here. The process is:

1) Backup, and then restore database.
2) Backup, and then restore the schema holder (mfgsyssh files on the epicor server) using the probkup and prorest (both use the same format: proxxxx mfgsyssh backupfile
3) Run the Schema UD Update tool

Navigate to E9 Support -> Downloads, Click on the Epicor DMT Node in the tree you will then see the release notes, trial licenses and documentation which includes PDF's and CSV's for all DMT Imports, along with a scripting guide.