iUPDATE Files

iUPDATE Installation and Setup

Last Updated:
7/13/2007 7:50:44 AM

Table of Contents

1.	Installation	

2.	Setup	

2.1  iUPDATE Database Setup	

2.2  iUPDATE Initial Setup	

2.3  Server Type Setup	      

2.4 Server Setup	



1. Installation

Installation of iUPDATE is relatively straightforward.  After having downloaded the .msi installation file, double click to execute.  The installation process follows the standard Windows application installation process.  After installation is complete, there will be a new folder under the Start Menu called iUPDATE, as well as a desktop shortcut.  

Removing iUPDATE from your system can be done through the “Add/Remove Software” function found in the Control Panel.


2. Setup

2.1	iUPDATE Database Setup

iUPDATE requires a back-end SQL Server database to function.  In the installation directory, find the “iUpdate Schema Data.sql” file.  Open this file using SQL Server Management Studio and execute.  This file will create a new database called iUPDATE, as well as create all the tables and stored procedures necessary for iUPDATE to function.  Optionally, a new SQL Server login and user can be created for this database to allow iUPDATE to connect to the database.

		
2.2	iUPDATE initial Setup

After Creating the iUPDATE backend database, start up the iUPDATE application for the first time.  Go to File -> iUPDATE Options to bring up the iUPDATE Options screen.  In the “iUPDATE Config” tab fill in the proper information, including:
-	Backend Database Server IP
-	iUPDATE Database Name (iUPDATE is default unless a different database name was used in Section 2.1
-	Backend Database Server Login
-	Backend Database Server Password
-	Error Log File Path (Click “Browse” and locate the file called “iUPDATE Error Log.log” in the iUPDATE installation directory
Click on “OK” to save these settings.

 


2.3	Server Type Setup

iUPDATE uses Server Types to group SQL Server that are used for similar purposes.  A Server Type can have one or many database associated with it, which should represent the actual databases that are on a server of that type.  

To set up Server Types in iUPDATE go to File -> Manage Servers and click on the “Manage Server Types” tab.  To add a new Server Type, enter the Server Type Name, then add databases to the Server Type.  Save the server type to the iUPDATE database by clicking on “Add/Update Server Type”

 


2.4	Server Setup

After creating at least one server type in section 2.3, server entries can now be added to iUPDATE.  In the “Manage Servers” screen, go to the “Manage Servers” tab.  To add a new server to the iUPDATE database, first select the Server Type in the drop down menu then fill in the following information:

-	Server Name – the name that will be displayed in iUPDATE
-	Server IP Address – IP address of the physical server
-	Server Instance Name – Only required if the SQL Server is an Named SQL Server Instance
-	Login Name* – A server login that is a DB Admin on the server
-	Login Password* – Server login password

•	Both the Login Name and Login Password will be encrypted in the iUPDATE backend database.

Click on “Test Connection” to test the connection to the server using the login name and password entered.  Click on “Add/Update Server” to save the server entry in the iUPDATE backend database.  

Click on “Close” to return to the main form.  You should see the Server Type, Target Database, and server list now populated with the information that you entered in the setup.  At this point, iUPDATE is setup and ready to use.