Home » Categories » Setup / IT information

Upgrading to SQL 2008 Express

Overview

Following are the steps to upgrade to SQL version on your Server. 

Detailed Instructions

Before You Begin - Requires TDO Backup

Prior to beginning it is REQUIRED that a backup be made of the TDO Server Data. This backup has to be run using the TDO Backup utility. No exceptions. Please make sure the backup completes without errors. If it completes with errors, please resolve that issue first as it will be necessary to use this backup in the process of upgrading SQL. If this is not done correctly, you will very likely lose data.

-Login to tdo4endo.com and in the Download TDO area, download the SQL2008Express.exe or the SQL2008Expressx64.exe installer and save it to your TDO Builds directory. (Please remove or archive any old installers for SQL from this folder)

-Ensure no one is using TDO and that TDO has been closed on all computers.

-Stop TDO Cloud Service (if using TDO Cloud Service).

-Stop TDOSQLSERVER process in Administrative > Services.

-Uninstall old version of SQL Server (likely MSDE or SQL Server 2005 Express).

-Open Windows Explorer to your TDOfficeData directory and clear out all files in the root of that directory leaving all folders intact.

-Run TDOProfessional installer selecting server as the installation type. This will install the newer version of SQL Server providing it is in the TDO Builds directory as previously directed.

-Upon completion, open TDO to verify the installation was successful. (The database will be blank).

-Close TDO.

-Launch the TDO Backup utility and ensure the backup path points to the directory containing the server data backup that was run.

-Ensuring that only Server Data is checked, click the Restore button.

-Follow any on screen prompts

-Check that the Restore completed without errors.

-Restart the TDO Cloud Service

-Launch TDO to verify that the SQL upgrade has completed successfully.

0 (0)
Article Rating (No Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
How to integrate the GentleWave Console with TDO Software
Viewed 1829 times since Aug 15, 2018
How to Upgrade Access Runtime 2002 to 2010
Viewed 2230 times since Sep 27, 2016
Carestream 1200 and 1500 Intraoral Camera Setup
Viewed 866 times since Nov 15, 2018
Microsoft SQL Size Limitations by Version
Viewed 529 times since May 23, 2018
TDO Workstation Install (Version 11)
Viewed 7098 times since Feb 13, 2015
Minimum Software and Hardware Requirements
Viewed 8612 times since Aug 26, 2014
Restoring From a TDO Backup (Running A Fire Drill part. 2)
Viewed 1331 times since Nov 15, 2017
Adding Dental Exchange information into TDO
Viewed 2133 times since Jun 8, 2015
TDO integration with CloudPBX software
Viewed 1153 times since Jan 20, 2018