Skip to content

DataSplice Support Website

Sections
Personal tools
You are here: Home » Product Manuals DataSplice 2.3 » DataSplice 2.3 Installation Guides » MAXIMO 5.x Plug-In Installation Guide » Creating the DataSplice Views on SQL Server
 

Creating the DataSplice Views on SQL Server

Executing the view creation scripts on SQL Server creates the associated DataSplice views. To execute the scripts on SQL Server, follow these steps:

  • Log in to SQL Query Analyzer as the database owner or system administrator.
  • Open the DS_Views.tsql file. By default, the file is located in the C:\Program Files\DataSplice\Scripts\SQLServer directory.

Open Query File

  • Once the file is open, click the Run button Run Button to execute the script. The first time the scripts are executed, it is normal to experience the "Can Not Drop" object error.

Script 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:

Query

After successful completion of the script execution, the appropriate DataSplice views will have been created.

Contents
 


Last modified 2005-07-05 12:11 PM
 
Powered by Plone

This site conforms to the following standards: