Please contact your System Administrator if you need assistance with the following:
o Ensure you have logged into Windows with local Administrative privileges.
o Ensure you have installed Bluechip on the Server computer.
o If you are using Full SQL 2005 or 2008, you will need to download the required SQL Studio Management Tools from the Microsoft web site.
You will need to be on the Server computer. The 2005 SQL Studio Management installation file is installed with a default Bluechip installation, and can be found in the following location:
o 32 bit - C:\Program Files\Health Communication Network\Bluechip\Tools\
o 64 bit - C:\Program Files (x86)\Health Communication Network\Bluechip\Tools\
o On the Bluechip CD, browse to \Microsoft SQL Server 2005 Express\ SQLServer2005_SSMSEE.msi
There are two versions (32-bit and 64-bit) of 2005 SQL Studio Management Studio Express. These are for 2005 SQL installations only - if you are using SQL 2008 please refer to Before You Begin, above.
o 32 bit - SQLServer2005_SSMSEE.msi
o 64 bit - SQL Server2005_SSMSEE_x64msi
1. Browse to the location of your Bluechip Database.
2. Copy (do not ‘cut’) the Bluechip Database.
3. Paste the Bluechip Database in either of the following locations, according to your SQL version and operating system:
|
OS Version |
SQL Version |
Folder Location |
|
32 Bit |
SQL 2005 |
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ |
|
SQL 2008 |
C:\Program Files\Microsoft SQL Server\MSSQL10.HCNSQL07\MSSQL\DATA\ |
|
|
SQL 2008 R2 |
C:\Program Files\Microsoft SQL Server\MSSQL10.HCNSQL07\ MSSQL\DATA\ |
|
|
|
|
|
|
64 Bit |
SQL 2005 |
C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ MSSQL\Data\ |
|
SQL 2008 |
C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.HCNSQL07\ MSSQL\DATA\ |
|
|
SQL 2008 R2 |
C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.HCNSQL07\ MSSQL\DATA\ |
4. Start SQL Server Management Studio.
From the Windows Start menu, select All Programs. Within the list of programs, locate Microsoft SQL Server and then locate and click SQL Server Management Studio.
Note: On Windows 7 computers, you may need to right-click SQL Server Management Studio and select ‘Run as Administrator’.
5. Once SQL Server Management Studio has opened, you will be presented with a Connect to Server window. Check the following is correct then click Connect.
o Server Type: Database Engine.
o Server name: Server Name/HCNSQL07
o Authentication.
6. You will be presented with the Object Explorer screen.
7. Click on the + to expand the databases.
8. Right-click Databases, and select Attach.
9. Click Add on the Attach Databases window. If at this stage you are presented with an error message, it may be you need to run SQL Server Management Studio with Administrative Privileges. Close SQL Server Management Studio, return to Step 4 and follow the instructions written under the Note there.
10. The Locate Database File window will be presented. Select the Bluechip database.
11. Click OK.
12. You will be presented with the Attach Database window. Click OK.
The Bluechip Database is now restored.
To switch between the Demonstration database and the customer’s Live database, follow the instructions below:
1. Browse to the following location
o Standalone Role
• 32 Bit - C:\Program Files\Health Communication Network\Bluechip\BlueData
• 64 Bit - C:\Program Files (x86)\Health Communication Network\Bluechip\BlueData
o Server Role
• XP - C:\Documents & Settings\All Users\Documents\Health Communication Network\Bluechip\BlueData
• Win 7/2008/2011 - C:\Users\Public\Health Communication Network\Bluechip\BlueData
2. Locate and copy the entire BCDemo folder.
3. Paste the BCDemo folder into the same location.
o Rename the copied BCDemo database to the customer’s database name.
1. Locate and open the database.inf file.
2. Highlight and copy all text between and including the lines [BCDemo] and DBSQLDatabseImport=none
3. Create space at the end of the file by pressing Enter.
4. Right click and Paste the text.
5. Change all references of BCDemo in the copied data to the customer’s Database name (as shown in bold below)
6. Save the changes
[BCDemo]
DBSQLUsername=sa
DBSQLPassword=9E0D2134DCEB08B4FE13DBF934AFB9DBC85D11C85D9284C9
DBSQLServer=Server Name\HCNSQL07
DBSQLDatabasePractice=BCDemo07
DBSQLDatabaseImport=none
[Customers Database Name]
DBSQLUsername=sa
DBSQLPassword=9E0D2134DCEB08B4FE13DBF934AFB9DBC85D11C85D9284C9
DBSQLServer=Server Name\HCNSQL07
DBSQLDatabasePractice=Customers Database Name
DBSQLDatabaseImport=none
[CurrentVersion]
BlueChip=2.8.2.0
Now when Bluechip is started, both the demonstration database and the customer database will be available for use.