Transfer Jobs Database from old computer to new computer

To transfer your database from an old computer to a new one, please follow these instructions:

1. On your old computer,
   1. open Con-Nex or Quick Order Entry and go to the Tools Menu> Data Sources> SQL Server Admin.
   2. Click on the Backups Tab and then select Create Backup. Note that it will tell you the file path for the backup at the top.
   3. ***IF AND ONLY IF THE SQL INSTANCE NAMES (SQL2008EXPRESS vs ADVANCEWARE) are different on the 2 pcs, make note of where the AWJobsDB.mdf and AWJobsDB.ldf files are located on this old PC.
      1. The files will be in one of these 4 locations by default
         1. C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.SQL2008EXPRESS\MSSQL\DATA
         2. C:\Program Files (x86)\Microsoft SQL Server\MSSQL12.ADVANCEWARE\MSSQL\DATA
         3. C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2008EXPRESS\MSSQL\DATA
         4. C:\Program Files\Microsoft SQL Server\MSSQL12.ADVANCEWARE\MSSQL\DATA
2. Transfer the information
   1. If you are using a flash drive to transfer the database to your new computer, navigate to the backup file location. Save the file to a flash drive.
   2. If you are going to use email to transfer the database to your new computer, open your email and add the backup file as an attachment.
3. On the new computer, (if existing database, backup first)
   1. plug in the flash drive, find the database backup file on the flash drive and save it on your computer.
   2. Or, if using email, save the attachment to your computer.
   3. ***IF AND ONLY IF THE SQL INSTANCE NAMES (SQL2008EXPRESS vs ADVANCEWARE) are different on the 2 pcs, create an empty folder with the same path and name to match the location where you found the 2 files in Step 1.3 above
   4. Open Con-Nex or Quick Order Entry on your new computer and go to the Help Menu> Tech Support> SQL Server Admin.
   5. Click on the Backups tab and next to the Location bar, click browse.
   6. Browse to the location on your computer in which you saved the Backup file. Once selected, hit the Restore button.
4. You should now be able to open your jobs on your new computer.