Moving Your MedicalDirector Blue Chip Data to a New Server Computer

 

This document will guide you through moving your MedicalDirector Blue Chip 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 MedicalDirector Blue Chip CD release.

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

o       Your MedicalDirector Blue Chip Store password, or Medicare Australia Location Certificate CD and PIC Passphrase.

 

Determine your installed version of the MedicalDirector Blue Chip

1.     Open MedicalDirector Blue Chip.

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

 

 


On the Old Server Computer

Backup the MedicalDirector Blue Chip Data

Scenario 1:  .Bak Files

1.     Run MedicalDirector Blue Chip

2.     Select BC Tools > HCN Backup

3.     Run the Backup Utility. Please see the MedicalDirector Blue Chip 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 MedicalDirector Blue Chip 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 MedicalDirector Blue Chip Documents

(If you do not scan from within MedicalDirector Blue Chip, 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\Blue Chip\Bluedata\Database Name\Imaging

o       In Win7/8/10 - C:\Users\Public\Health Communication Network\Blue Chip\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 MedicalDirector Blue Chip

Install MedicalDirector Blue Chip 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 MedicalDirector Blue Chip Database

Scenario 1:  MDF and LDF files

1.     Browse to the location of your MedicalDirector Blue Chip 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 MedicalDirector Blue Chip 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 MedicalDirector Blue Chip 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 MedicalDirector Blue Chip 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 \Blue Chip  \Bluedata \Customer_database_Name \Imaging

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

 

Restore the MedicalDirector Blue Chip 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 MedicalDirector Blue Chip for Online Claiming

1.     Open MedicalDirector Blue Chip.

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\Blue Chip

2.     Open the Bconfig.exe

3.     Select the Customer Database, click OK.

4.     You will be presented with the MedicalDirector Blue Chip 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 MedicalDirector Blue Chip Demo Database

Configure MedicalDirector Blue Chip for Online Claiming

1.     Open MedicalDirector Blue Chip.

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 MedicalDirector Blue Chip and ensure you are able to view and save letters and documents, if you encounter any errors please contact MedicalDirector Customer Care.