How to Move or Merge EzDent-i database

Written on Aug 15, 2019

It is highly recommended that this guide be used only by qualified IT Consultants to move or merge EZDent-i database in accordance with HIPAA. All proper backups must be made in advance of conversion process. Vatech America holds no liabilty in the event of failure to follow recomendations or proper adhearence to conversion process steps.

PDF Guide can be downloaded from the following link: EZDenti Move or Merge Guide for IT Consultant

 

WARNING: Before proceeding, please verify that you have a proper, working backup.

If no backup is made in advance please follow these guides on DB Back Up for your Software System:

https://vatechamerica.com/faq/software/how-to-backup-ezdent-i-software

 

Things to check first:

  • Target DB can only be migrated once. Duplicate charts and Conflicting Chart numbers will not be migrated and will need to be done manually.
  • Source is where the current DB to be migrated resides
  • Target is where the new DB will be migrated to.
  • Ensure that the target hard disk has sufficient free space before starting.
  • Network speed will affect the transmission of the migration through the office network.
  • Makes sure EzDent-I VT File Manager are running
  • on both Source and Target PCs.Make sure EzDent-I PostgreSQL are running on both Source and Target PCs.Source and Target PC’s EzServer versions must match.

Once back up is confirmed good and working, we may continue to the first step.

 

Installation of EZServer

Please install EzServer on to the PC you want the EzDent-I DB to reside on.

You may find the download link for EzServer, ConsultData, and ImplantData here:

https://vatechamerica.exavault.com/share/view/lpds-c6wslyc5

 

To determine the version of EZServer:

-Right click on the VTFilemanager and click 'About'

Once you have verified the version, compare with the following chart to confirm which version tool to use.

The Migration tool is placed on the source PC with the target DB to be migrated.

 

Migration tool:

1st: Migration tool can be found in the following link:

https://vatechamerica.exavault.com/share/view/1mlhq-dhan5dr2
 

2nd: Extract the Migration tool zip folder and Navigate to the Bin folder in the VTMigrator folder:

And run the VTMigration.exe to start and the Analysis screen will open:

3rd: In Migration Type, select the software you want to migrate:

You must select: EzDent-I -> EzDent-I

EzDent-I -> EzDent-I migration can only be done through the network.

 

Click Search Server and locate the correct IP Address of the new target location of the EzDent-I DB.

  • You will need to have already installed EzServer on the other target location.
  • You may need to change the port number to match installation of EzServer. (Default:55001)

You would use this to move the EzDent-I DB from the Capture PC to an office server or one office server to another new server.

  • The migration tool leaves the source intact, so it is recommended to keep these files as a back up.

Data Range: Range is an option for you to migrate data from a certain period only. Select this option to migrate data of a certain period. Deselect the option to migrate entire data.

4th: Once you are ready please press Start.

Please refer to the Appendix for more information found on the window above.

5th: When the migration is complete, you will get a Migration Report.

The number of migrated patients of the result report represents the number of patients whose data was successfully migrated.

  • The report can be found in the Report folder as “Report[Migration Date].txt”
  • For any failed files, you may try the Retry Failed Files button to try and migrate that data over.

Failed files are files that cannot be migrated due to conflicts, or do not exist anymore (may have been deleted/moved).

  • The report will give you the reason for the failure and you may need to manual import the Chart and files over to EzDent-I, if possible.

When selecting EzDent-I -> EzDent-I, only the patient information and image data are migrated and the following are not merged:

  • You will now manual upload any patient charts that did not migrate over.
  • You will also need to install the ConsultData and ImplantData (If needed) on the PC where the EzServer was installed.

When selecting EzDent-I -> EzDent-I, only the patient information and image data are migrated and the following are not merged:

  • Setting data
  • FMX Layout created by FMX Layout Editor
  • Implant DB
  • Consult related data
  • Consult category info and contents
  • Report file and related info
  • Ez3D-I related data

Appendix:

Source Info: Source environment analysis info

Patient Count: Total number of patients for migration (duplicate patients are excluded)

File Path (or IP): Source file path for migration

Fie Count: Total number of images for migration

Valid File Count: Number of valid image files

Invalid File Count: Number of invalid image files

Total Valid File Size: Total size of valid image files

Require Space: Required space for files

Target Info: Target environment analysis information

File Path (or IP): Target file path for migration

Free Space: Available disk space

Analysis Report button: Display the detailed report information of the analysis stage

Reset button: Return to the analysis setup stage

Start button: Execute migration

Related Products

Counts indicate more articles with the same products