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

 

 

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.

o       Ensure you have the latest full Bluechip CD release.

o       Ensure you have logged into Windows with local Administrative privileges.

o       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 > HCN Backup

3.      Run the Backup Utility. Please see the Bluechip Help for instructions on performing a backup.

 

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

(If you do not scan from within Bluechip, skip this step)

1.      Browse to the following locations and copy the folder ‘Documents’ or ‘Imaging’ to an external drive.

o       C:\Manageezy\HCN\Documents

or

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

Default backup location is C:\HCN\Backup

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

Default installed location:

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

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

 

 


On the New Server Computer

Install Bluechip

Install Bluechip using the latest full version release CD

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

 

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

 

Restore the Bluechip Documents

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

o       C:\Manageezy\HCN\Documents, or

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

o       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

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