Copying data between OASIS databases is useful for a number of reasons, including:
restoring deleted transactions from a backup
copying data from an office database to a central database
Copying data from one OASIS database to another OASIS database is done through these steps:
Connect to the correct "from" database!
Find the data to move
Export the data to a file
Disconnect and connect to the correct "to" database!
Use the database copy tool to import the data
Connecting to the correct "from" database is almost as simple as logging into OASIS. For small offices, the best option is to stop the OASIS database using the OASIS database configuration tool. Then manually start the database using the oasis.db file from the backup database (it is common for the database to be in a folder named oasis_backup: d:\oasis_backup\oasis.db is an example).
Once you login to OASIS, look for the item to be move. In the example below, the orders for the past week are copied:
Select the orders application
Click on "File" the "Find"
Select Update Date "Last Week" to "Last Week"
For our sample database, the following shows. We also type <CTRL> and "A" to select all rows:
Next, click on the "File" the "Export" menu item. This will export all selected transactions (could be quotes, manufacuters, etc.) to a file. Any file name may be used:
This will create a compressed file with the transactions (the oasisz file format):
The file may be moved using any file copy method.
Log out of OASIS and connect to the database to receive the data. Please make sure you select the correct database! For most users, simply stop the database and restart using the OASIS database configuration tool.
Typically, users perform a search for recent orders or quotes to confirm that the correct database has been connected to. Just look for data you would expect in the database to receive the copied data.
Once logged into the correct database, select "Configuration" the "Software":
Select "Database Copy":
Select "Source File" and select the file name by pressing the "..." button to locate the file exported from the other database. Press "Next":
Don't change the target database (you are already connected to the proper database). Press "Next":
Select the transaction types you are moving. This is a little protection to prevent moving the wrong data. In this example, we are copying orders - so no items are checked. Press "Next":
For this example, we are moving orders, so "Purchase Orders" are selected. Press "Next":
This is the confirmation screen. Press "Ok" to start the copy...
As a final step - search for the items that were copied.