Upgrade DIGITALTAKOFF from SQL 2014 to SQL 2022 or 2025

Task 1: Backup SQL / Digital Takeoff

1. Stop the SQL DIGITALTAKEOFF service
   1. Control Panel > Services or Start>Run>Services.msc
   2. Select SQL Server (DIGITALTAKEOFF)
   3. Right-click > Stop
2. Locate the SQL data files (the folder will contain multiple .mdf & .ldf files including DIGITALTAKEOFFJOBS as well as a set for each Digital TakeoA job in the form of -.mdf & .ldf). These could vary slightly (SQL 2014: C:\Program Files (x86)\Microsoft SQL Server\MSSQL12.DIGITALTAKEOFF\MSSQL\DATA)
3. Copy all files in the SQL DATA folder from the source computer to an intermediate folder. 

Task 2: Uninstall SQL / Digital Takeoff

1. Navigate to Control Panel / Programs and Features
2. Locate Microsoft SQL Server 2014.
3. Uninstall 

Task 3: Install SQL Express Instance

1. • Confirm compatibility for the desired version of SQL.

   • Install SQL 2022 Express

1. • • For Estimation Desktop version 13.2 or later, Run the Datasetup file for that corresponding version. [IMPORTANT, if running on a network/serfer: When prompted for the installation path, overwrite with UNC path, format: \\ServerName\ShareName.]
     • For Estimation Desktop version 13.1.2 or earlier, follow the instructions for How to Manually Install SQL 2022 Express and Management Studio for Digital Takeoff

2. • Install SQL 2025 Express

     • If desired, and if Follow the instructions on How to Manually Install SQL 2025 Express and Management Studio for Digital Takeoff

Task 4: Migrate Databases into new instance.

1. Copy SQL files from the intermediate folder to the folder where the SQL data is installed.

• • 2022: C:\Program Files\Microsoft SQL Server\MSSQL16.DIGITALTAKEOFF\MSSQL\DATA
  • 2025: C:\Program Files\Microsoft SQL Server\MSSQL17.DIGITALTAKEOFF\MSSQL\DATA
  • If duplicates are found, skip all.

2. Attach the migrated databases [Note: for more than 50 databases, Support can assist]
   1. On the destination computer, launch SQL Server Management Studio by navigating to All Programs > Microsoft Server Tools > SQL Server Management Studio.
   2. Connect to the DIGITALTAKEOFF instance

• • • Authentication: SQL Server Authentication
    • Login: LogisticsDT
    •  Password blank
    •  Encryption: Optional.

1. 3. Under the DIGITALTAKEOFF instance, right-click Databases and click Attach.
   4. Click Add, Browse to the DigitalTakeoffJobs.mdf, click OK.
   5. For each of the other migrated digital takeoff jobs, click Add, Browse to the .mdf file, click OK. Repeat until you have added all .mdf’s that were migrated to the list
   6. On the Attach Databases window, click OK
   7. Wait for all databases to be attached and address any errors that display
   8. Close SQL Server Management Studio.