Wiki

Case Status
Log In

Wiki

 
Copying data between OASIS dat…
  • RSS Feed

Last modified on 7/15/2014 1:53 PM by User.

Tags:

Copying data between OASIS databases

Overview

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

The Steps

Copying data from one OASIS database to another OASIS database is done through these steps:

  1. Connect to the correct "from" database!
  2. Find the data to move
  3. Export the data to a file
  4. Disconnect and connect to the correct "to" database!
  5. Use the database copy tool to import the data

Connect to the correct "from" database!

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).

Find the data to move

Once you login to OASIS, look for the item to be move. In the example below, the orders for the past week are copied:

  1. Select the orders application
  2. Click on "File" the "Find"
  3. 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:

Export the data to a file

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.

Disconnect and connect to the correct "to" database!

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.

Use the database copy tool to import the 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.