For organizations with production and test databases (you do have a test environment, don't you?), copying updated production data into the test environment can be cumbersome. Rather than having to back up the production data and restore it into the testing database, you can use the datapump command-line tool.
Steps in This Task
Determine the source and target databases. A database's name can be either its backend plus a colon plus name, e.g. "SQL Server: Production" or its nickname.
Make a backup. When you run this task, VSys does not verify that you aren't moving the wrong database to an even more wrong location, e.g. an evaluation database onto your production database. So back up the production database just in case.
Get to a Windows command line in the folder that VSys.exe and VSys.ini are located.
Enter the command line VSys.exe datapump:source,target Where source is the production database's name or nickname, and target is the test database's name or nickname.
For each VSys-recognized table in the source database, VSys will delete that table in the target database and re-create it with the contents of the table from the source database.
