Create Staging DB

SAGE STAGING DATABASE SETUP

Before you actually set up your ODBC connection on the Sage server, You will have to set up your Staging DB on your database server. This staging db acts as an intermediary database for the data being exported/imported to Sage. As we use Sage inbuilt mechanism to export and import data in and out of sage i.e visual integrator which has no control the data being moved. All the data mashing happens in this database so that duplicate records are not processed to Sage.

The database script attached is of MYSql, you can download the following attachment and import it in your mysql database as explained the latter sections.

Sage

or Alternatively if you are using any other database you will to download the schema of  in HTML version to create a database as per your choice.

SageStaging.htm

Steps To Import Staging DB Script

The below are the steps that need to be followed while setting your staging db in your database server. 

1. Open SQL yog with you user name and password, Make sure your user has all the permission for creation of tables and its objects.
2. Create a database with the name of your choice.
3. On the database which you had created, Right click and go to option Import → Execute Sql Script will open a file dialog box.
4. Select the script from your download folder and Click Execute for successful import. 
5. Expand the tables, view, trigger to see for the tables and its objects have been successful imported.