Sept 21, 2019 Notes about doing File Migration for Dentrix and Dexis by Mark P Miller, P.E. 228-218-9523 http://primo.ws From Server2008 (Old OEM-Server 2008R2 OS) to Server (New Dell T320-Server2016 OS) Instructions: On old Server, check Shadow Copies and make sure latest ShadowCopy date/time stamp is current Navigate to C:\disks\Backup-Shortcuts\Migration and run script as administrator Script name is RCopy-Both-Dentrix-Dexis-Shadow2.cmd When finished, both Target Folders are opened so robo.logs can be viewed. Rename the logs so they are not overwritten by subsequent runs If logs are big, copy beginning and end pieces and create a summary log Finished On initial runs, Dentrix took approximately 1.5 hours and Dexis about 4 hours for 6.5 hour total ---------------------------------------------------------------------------------------------------------------- RCopy-Both-Dentrix-Dexis-Shadow2.cmd Genrated this Script to ShadowCopy Dentrix and Dexis Folders On New Server Share C:\DENTRIX\Common and C:\DEXIS Imaging Suite, Run Script from Old Server at C:\disks\Backup-Shortcuts\Migration, Source1: C:\MyShadow\Dentrix\Common, Target: \\Server\Common Source2: C:\Server\DEXIS Imaging Suite\DATA, Target:\\Server\DEXIS Imaging Suite\DATA Logs: \\Server\DEXIS Imaging Suite\robo.log and \\Server\Common\robo.log @echo off echo Be sure to check that Shadow Copy Date is current (C,Properties,Shadow Copies) C: cd "C:\disks\Backup-Shortcuts\Migration" net use T: /Delete net use T: \\Server\Common /user:user network1 net use U: /Delete net use U: "\\Server\DEXIS Imaging Suite" /user:user network1 Call C:\disks\Backup-Shortcuts\Migration\MountLatestShadowCopy.bat C:\MyShadow\ rem net use rem dir C:\m*.* /d echo About to echo RoboCopy C:\MyShadow\Dentrix\Common to T:\ echo RoboCopy C:\MyShadow\DEXIS Imaging Suite\Data to U:\DATA echo echo Press Ctrl-C to Abort or pause robocopy C:\MyShadow\DENTRIX\Common T:\ /XO /S /Z /B /W:2 /R:2 /LOG:T:\robo.log /XF pagefile.sys robocopy "C:\MyShadow\DEXIS Imaging Suite\Data" U:\DATA /XO /S /Z /B /W:2 /R:2 /LOG:U:\robo.log /XF pagefile.sys RD C:\MyShadow rem pause start T:\ start U:\ --------------------------------------------------------------------------- 9-22-2019 Noticed a new Folder under Dentrix, "DB" with current date stamps made a new Script RCopy-Dentrix-Shadow.cmd to copy all Dentrix Folder including this one Ran before proceeding with Install --------------------------------------------------------------------------- 9-22-2019 Migration Steps Used Instructions from Article Id:73388 as instructed... http://50.205.195.209/?cid=147&c=12&cpc=r712Q06X7iHutoP6Svei8cs1vJiUUP8s#tab:homeTab:crumb:8:artId:73388:src:article 1. On Old Server, Performed a manual Database Export using _ServerAdmin.exe 2. Made Backup of C:\DENTRIX to \\Server\DENTRIX\DENTRIX-OLD_Server 3. Made Backup of C:\DEXIS Imaging Suite to \\Server\DEXIS Imaging Suite 4. Began Installation from C:\Disks\Dentrix 5. Chose Create Blank Database, Typical Install, PassPhrase = Gulf$Islands9010 6. Exported the Blank Database 7. Verified version 17.0.291.0 matching old Server2008 version 8. Renamed DBCopy Folder to DBCopyForBackup_BLANK_[17.0.291.0] 9. Followed the following instructions to migrate the data. Moved DentrixSQL to save time (72G) i. Run a New Export ii. Browse to the [drive]:\Dentrix\Common\ iii. Create a new folder called "Blank_Data" iv. Copy the Blank DBCopyForBackup, Blank DentrixSQL, and Blank Doc folders into the Blank_Data folder v. Access your backup copy of the "Common" folder. iv. Copy (Migrate) DBCopyForBackup, DentrixSQL, Doc and Templates (if on G6.1+) folders from your old server or backup media and paste it into your new [drive]:\Dentrix\Common\ folder, overwriting the Blank folders. 10. Ran SetStandardPermissions.exe from C:\DENTRIX\Common\Installs\Dtx G7\Dentrix\Prerequisites 11. Used Server Admin Utility to Restore the Database as instructed 12. Went to verify Shared Common Folder. Name was DTXCommon so added Common and removed DTXCommon. Then Re-read instructions and put DTXCommon back. Left both shares, confused. 13. Verified some data showing up, Rebooted. 14. On Old Server, Stopped DentrixAceService and set to Manual START OF DEXIS MIGRATION 15. Ran \DEXIS Imaging Suite\Data\Setup\Setup.exe 16. Was told it would install SQL but it did not. Found SQLEXPR Install Folder at C:\DEXIS Imaging Suite\DATA\Setup\msse2005 and Ran that 17. Got a warning that SQL 2005 was not compatible with this platform so I aborted. 18. Put things back the way they were Sept23, continued Got DEXIS in remotely to install SQL 2014 and DEXIS 10.1.6.3 Got Kyle online who did the install. Source Files at D:\Disks\DEXIS Installed version 10.1.6.3 Setup SQLExpress 2014 with Management Studio 2014 Attached Data, Ran Integrator sa password is *Dexis1 Instructions for Workstations, Launch DEXIS, Click Wrench, Data, Change Path to \\Server\DEXIS Imaging Suite\DATA Anytime Dentrix is updated, run DentrixIntegrator.exe on each workstation Support is open until 7pm Workstation Research Article # 34797 When entering paths for a workstation install, remember these simple, yet important, steps. 1. Leave the Destination folder on the Local C: Drive (ex. C:\program files\dentrix\) 2. Change the Data files folder to the network drive (ex. Z:\dentrix\data) 3. Change the Template files folder to the network drive (ex: Z:\dentrix\doc) 4. Leave the Tutor files folder on the local c: drive (C:\program files\dentrix\tutor\ Article # 61770 Open the registry hive: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Dentrix Dental Systems, Inc.\Dentrix\General If this value does not exist, create a new String value and name it: ServerMachineName Type the computer name of the server. (Simply type the name; do not use back-slashes or try to specify domain informaiton) Attempt the Workstation installation again. SQL DATA FOUND: C:\Program Files (x86)\Microsoft SQL Server\MSSQL.2\MSSQL\Data (ViperData.mdf, ViperData.ldf Sept2018, Dec2010) C:\DEXIS Imaging Suite\Data