|
Move To A Newer Version Of Microsoft SQL Server
Microsoft SQL Server 2005 Express has been the standard database in POSitive products for many years. However, Microsoft ended extended support for Microsoft SQL Server 2005 Express on April 12th 2016. As a result, we no longer support POSitive running against that version of SQL Server because it is considered vulnerable software... which makes it easier to compromise your data because Microsoft is no longer providing security updates for Microsoft SQL Server 2005 Express. Therefore, you should plan to move to a newer version of Microsoft SQL Server as soon as possible!
Even if extended support didn't end, there are other reasons to move to a newer version of Microsoft SQL Server. It's compatible with Windows 10, has better security, improved performance and is designed to handle larger databases.
Microsoft continues to offer a free Express edition of SQL Server. However, the Express edition is not suitable for all customers.
1. Express editions of Microsoft SQL Server cannot be used as the Publisher at the Master site for multi-site customers.
2. Express editions of Microsoft SQL Server cannot be used for databases that are larger that 10GB.
Both cases above require a Standard or higher edition. Be sure to consult with your POSitive reseller, IT consultant, and/or POSitive Support technician to find out which edition is best suited for your needs and to have one of them install it for you (POSitive upgrade/installation services for SQL Server may not be included in your Software Maintenance Subscription. Contact your POSitive Sales representative for details).
--- PROJECT SUMMARY---
!!! IMPORTANT !!!
This article does not apply to Multi-site customers or databases larger than 10GB. Contact your POSitive reseller, IT consultant, or POSitive Support technician to learn more.
This article focuses how to upgrade SQL Server 2005 Express using backup and restore to a new 'Instance' of Microsoft SQL Server 2016 Express. Although this option will work in most cases, you should consider consulting with your POSitive reseller, IT consultant, or POSitive Support technician to find out which method is best suited for your situation... because there are a number of factors which can cause installation problems and poor performance issues.
Instructions for alternative upgrade options are available on Microsoft's website.
Install a New Instance (recommended in most cases)
- Review the hardware and software requirements for installing the supported SQL Server edition you choose
- Review the hardware and software requirements for installing POSitive software
- Backup your database
- Install a new instance of Microsoft SQL Server 2016 Express Edition
- Restore your database
- Tell POSitive software where to find the database in its new location
- Configure SQL settings
--- BEFORE GETTING STARTED ---
!!! IMPORTANT !!!
This article does not apply to Multi-site customers or databases larger than 10GB. Contact your POSitive reseller, IT consultant, or POSitive Support technician to learn more.
Be sure you can view file extensions in Windows. Here's how:
- Open Windows File Explorer (Press the Windows logo key + E)
- Click the File, View or Organize menu option
- Select 'Options' or 'Folder and Search Options'
- Select the View tab
- Uncheck the option 'Hide extensions for known file types'
- Click OK to close
------------------------------
STEP 1: SQL SERVER HARDWARE AND SOFTWARE REQUIREMENTS
------------------------------
!!! IMPORTANT !!!
This article does not apply to Multi-site customers or databases larger than 10GB. Contact your POSitive reseller, IT consultant, or POSitive Support technician to learn more.
Review the hardware and software requirements for installing the supported SQL Server edition you choose
Back to top
------------------------------
STEP 2: POSITIVE SOFTWARE HARDWARE AND SOFTWARE REQUIREMENTS
------------------------------
Review the hardware and software requirements for installing POSitive software
Back to top
------------------------------
STEP 3: BACKUP YOUR DATABASE
------------------------------
Follow the instructions of our How to Backup Your SQL Database knowledgebase article
See: http://kb.gopositive.com/backupsqldatabase
Back to top
------------------------------
STEP 4: INSTALL A NEW INSTANCE OF MICROSOFT SQL SERVER 2016 EXPRESS EDITION
------------------------------
!!! IMPORTANT !!!
This article does not apply to Multi-site customers or databases larger than 10GB. Contact your POSitive reseller, IT consultant, or POSitive Support technician to learn more.
Follow the instructions of our How to Install Microsoft SQL Server 2016 Express Edition knowledgebase article:
See: http://kb.gopositive.com/installsqlserverexpress2016
Back to top
------------------------------
STEP 5: RESTORE YOUR DATABASE
------------------------------
How to Restore a Database Backup
See: http://link.gopositive.com/restoresqldatabase
NOTE:: Be sure to Connect to the NEW instance of the SQL Server that you just installed.
Back to top
------------------------------
STEP 6: TELL POSITIVE SOFTWARE WHERE TO FIND THE DATABASE IN ITS NEW LOCATION
------------------------------
Launch POSitive and select your company. When a connection error appears simply re-enter the new connection settings
Back to top
--------------------------------
STEP 7: SQL CONFIGURATION SETTINGS
--------------------------------
Configure the settings for your new SQL Server installation instance
See: http://kb.gopositive.com/sqlconfigtroubleshooting
Back to top
Updated 2/13/2017
| 