Moving Your Bluechip Data to a New Server Computer

This document will guide you through moving your MedicalDirector Bluechip data to new Server computer, and is divided into three manageable sections; Old Server, New Server, Workstations.

Note that this guide covers the installation and moving of MedicalDirector-related data and components only.

If at any stage you encounter errors, please contact MedicalDirector Customer Service.

Before you Begin

Please contact your System Administrator if you need assistance with the following:

o An external hard drive or other media for moving the data from the old server to the new server.

Ensure you have the latest full Bluechip CD release.

Ensure you have logged into Windows with local Administrative privileges.

Your MedicalDirector Bluechip Store password, or Medicare Australia Location Certificate CD and PIC Passphrase.

Determine your installed version of the Bluechip

1. Open Bluechip.

2. Select Help > About and note the installed version.

On the Old Server Computer

Backup the Bluechip Data

Scenario 1: .Bak Files

1. Run Bluechip

2. Select BC Tools > Backup

3. Run the Backup Utility.

Scenario 2: MDF and LDF files

1. In Windows, select Start > Run and type Services.msc

2. Locate and highlight SQL Server (HCNSQL07)

3. Right-click and select Stop

4. Browse to the location of your Bluechip database. It can be found in either of the following locations, depending to your SQL version:

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\

5. Copy (do not ‘cut’) the following databases:

o Practice Database Files (usually named with Practice Name or Doctor’s name)

• BCpractice.MDF

• BCpractice_log.LDF

o Manage Ezy Database Files

• HCN_MNGEZY.MDF

• HCN_MNGEZY_LOG.LDF

6. Paste the files to the backup location (C:\HCN\Backups)

Backup the Bluechip Documents

To include any scanned documents:

1. Browse to the following locations and copy the folders ‘Documents’ and ‘Imaging’ (if they are present) to an external drive.

o C:\Manageezy\HCN\Documents

o In XP - C:\ Program Files\Health Communication Network\Bluechip\Bluedata\Database Name\Imaging

o In Win7/8/10 - C:\Users\Public\Health Communication Network\Bluechip\Bluedata\Database Name\Imaging

2. Paste the files to the backup location (C:\HCN\Backups)

Copy the Backed Up Files to External Media

o Default backup location: C:\HCN\Backup

Backup the Hic.psi: Copy the hic.psi to the external drive.

o Backup the database inf file:

• This file contains information about your existing BC server and computers, such as the names of these machines, and can come in handy once you've setup the new server.

• Copy the hic.psi to the external drive.

o Default installed location:

• 32 Bit OS: C:\ Program Files\Medicare Client Adaptor

• 64 Bit OS: C:\ Program Filesx86\Medicare Client Adaptor

On the New Server Computer

Install Bluechip

Install Bluechip using the latest full version release disc.

Please Note: If the installed version is no longer available for download via MedicalDirector Automatic Update or from the MedicalDirector website, you will need to update the server and workstations to the current version, manually.

Restore Your Bluechip Database

Scenario 1: .BAK files from Backup Utility

1. 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.

2. 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

3. You will be presented with the Object Explorer screen.

4. Right-click Database, select Restore.

5. The Restore Database window will be presented, on the General Tab select Source.

6. In the Destination for Restore, To Database type the name of the Practice Database.

7. Under Source For Restore, select From Device, click the button.

8. Click Add, and browse to the location your database (.bak), click OK.

9. In Select Backup Sets to Restore, tick the Restore check box.

10. On the left, click Options.

11. In the Restore Options window, tick Overwrite the existing database.

12. Click OK.

Scenario 2: MDF and LDF files

1. Browse to the location of your Bluechip HCNSQL07 instance in either of the following locations, according to your SQL version;

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\

2. Browse to the location of the backup databases.

o Copy (do not ‘cut’) the Bluechip Database to the HCNSQL instance location

o Practice Database Files;

• BCpractice.MDF

• BCpractice_log.LDF

o Manage Ezy Database Files

• HCN_MNGEZY.MDF

• HCN_MNGEZY_LOG.LDF

3. Start SQL Server Management Studio.

o 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.

4. 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

5. You will be presented with the Object Explorer screen.

6. Click on the + to expand the databases.

7. Right-click Databases and select Attach.

8. Click Add on the Attach Databases window.

9. The Locate Database File window will be presented. Select the Bluechip database.

10. Click OK.

11. You will be presented with the Attach Database window. Click OK.

Restore the Bluechip Documents

Copy the Documents file from the external media to the following locations;

o C:\Manageezy\HCN\Documents, or

In XP - C:\ Program Files\Health Communication Network \Bluechip \Bluedata \Customer_database_Name \Imaging

In Win7/2008/2011 - C:\Users\Public\Health Communication Network\Bluechip\Bluedata\Database Name\Imaging

Restore the Bluechip Hic.psi

Copy the hic.psi file from the external media to the following location;

o 32 Bit OS - C:\ Program Files\Medicare Client Adaptor

64 Bit OS - C:\ Program Filesx86\Medicare Client Adaptor

Configure Bluechip for Online Claiming

1. Open Bluechip.

2. Setup > Practice > Batch Types.

3. Select your Medicare Online class e.g. HIC BB.

4. Click Configure Medicare Australia.

5. On the Location and Authentication tab, populate the following:

o Location Id = BCP#####

o Passphrase = Store Password

6. Click the button and browse to the location of the hic.psi on the new server.

7. Click OK.

Configure the Database.inf File

1. Locate and open the database.inf file Highlight and copy all text between and including the lines [BCDemo] and DBSQLDatabseImport=none

2. Create space at the end of the file by pressing Enter

3. Right-click and paste the text

4. Change all references of BCDemo in the copied data to the customer’s database name (as shown in bold below)

5. 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

On the Workstations

Update the Workstation Configuration

1. Browse to C:\Program Files\Health Communication Network\Bluechip

2. Open the Bconfig.exe

3. Select the Customer Database, click OK.

4. You will be presented with the Bluechip Database Configuration Window

5. Change SQL Server: Old Server Name\GCNSQL07 to New Server Name\HCNSQL07

6. Click Apply > Close.

7. Repeat the above steps for Bluechip Demo Database

Configure Bluechip for Online Claiming

1. Open Bluechip.

2. Setup > Practice > Batch Types.

3. Select your Medicare Online class e.g. HIC BB.

4. Click Configure Medicare Australia.

5. Select BcTools > HCN Backup.

6. Run the Backup Utility.

7. On the Location and Authentication tab, populate the following:

o Location Id = BCP#####

o Passphrase = Store Password

8. Click the ellipse […] button and browse to the location of the hic.psi on the new server.

9. Click OK.

10. Repeat the above on all workstations.

Open Bluechip and ensure you are able to view and save letters and documents, if you encounter any errors please contact MedicalDirector Customer Service.