DataSplice Releases Mobile Integration Suite 3.0
Executing the SQL Server Scripts
Executing the SQL Server scripts builds the necessary database views, packages, and procedures. Before you can begin to execute the SQL Server scripts, complete the following steps:
- Unzip the
ds_ss_max41_scripts.zipfile to a specific location, such asC:\temp\scripts. - Log in to SQL Query Analyzer as the dabase owner or system administrator.
Executing the Scripts Individually
The SQL Server script files should be executed in the following order:
dsutility.tsqlequipment.tsqlinventory.tsqlworkorder.tsqlworkplans.tsqltooltrans.tsqlds_permissions.tsql- optional (see below)add_ds_users.tsql- optional (see below)
To execute a SQL Server script:
- Open the script file:
- Click the Run button
to execute the script. The first time the scripts are executed, it is normal to experience the "Can Not Drop" object error.
- These errors occur because the scripts have been set up to drop objects before they are recreated. Since it is the first time running the scripts, there are no objects to initially drop. The scripts will run successfully the first time, even though you may receive this error. If you choose to run the scripts again, which is not required, it should complete without any errors:
- Repeat the execution process for the remaining scripts.
User DB Connection Setup
The last two scripts, ds_permissions.tsql and add_ds_users.tsql, are optional. They are only necessary if you intend to use the User DB Connection option for the database connection profile in the DataSplice Administration Client. This option passes the credentials of the user that logs in to the DataSplice Remote Client to the database, rather than the credentials specified for the connection profile in the Administration Client. For more information about the User DB Connection setting, please see the Connection Profiles Tab section of the DataSplice Administration Client User Manual.
Last modified 2005-03-22 08:43 AM
