You could create a batch files using Tabcmd get functionality to do this.
Use the tabcmd get function to download the data source from the Prod Server, and then Tabcmd Publish to publish to the Test Server
One thing to note is that as you are overwriting the Data source on the test server, and you have revision history enabled then all the old versions of the data source (including the extract) will be kept. (in revision history)
This may get quite large (depending on how large the extracts are, so you may need to do some cleaning out, or disable revision history
All the best
Okay. So to publish the files between servers I have to use the tabcmd and is there any way to automate the process?
You can put the commands into a batch file, and schedule the batch file using Windows Task Scheduler
All the best
Why mirror just the extracts? Why not do a full restore of PROD's backup to TEST with a script? Just be sure to use tabadmin restore with --no-config flag.
I would like to mirror selected workbooks and extracts only. I know I can restore the PROD's backup but there may be possibilities that the new workbooks are still under review before it moved to PROD and I don't want to overwrite with PROD info.