Difference between revisions of "Swansea"

Revision as of 12:49, 2 November 2015

Create a Blank IBID Database (IBID2)

Perform the following on UHSM-IBID2:

1) Download the 3 files from the Swansea section of the downloads on www.IBIDB.org into a folder called "Swansea" (or something equally as memorable)

2) Open Microsoft SQL Server Management Studio

3) Open the menu File -> Open -> File...

4) Navigate to the folder from step 1) and select the file called SWANSEA_IBID_38.25_DB.SQL

5) Click Execute on the toolbar

You're blank database, called Swansea is now created.

Point AquilaServer at the Swansea database (IBID1)

Perform the following on UHSM-IBID1:

1) Open the Notepad application (Start menu > All Programs > Accessories > Notepad)

2) File > Open

3) Change the drop down list from Text Documents (*.txt) to All Files

3) Go to the folder C:\Program Files\Evolution Healthcare Systems Limited\AquilaServer\

4) Open the file AquilaServer.INI.

5) Change the ConnectionString to point to the Swansea database, like this:

   [Settings]
   ConnectionType=MSSQL
   ConnectionString=AnyDAC?AuxDriver=MSSQL;Server=BLACKBOX;Database=SWANSEA;UserID=sa;Password=ehspass123;
   SessionTimeout=240