SQL Server 2008

By June 18, 2019Uncategorized

You may already be aware that SQL Server 2008 currently used to host Scuba/CentreStage databases will no longer be supported by Microsoft after 09/07/2019. Please see https://www.microsoft.com/en-gb/sql-server/sql-server-2008 for more information.

Delta will, for a period of time, continue to provide support for its applications utilising SQL Server 2008 however we recommend migrating to a current version for improved security and performance.

Server migrations sit outside of the usual services provided by Delta and as such are usually carried out by your own IT support. Delta can conduct server migrations however this is a chargeable service with quotes available upon request.

As a brief overview, you may wish to review the following considerations and suggested actions with your IT support and management team in order to make an informed decision as to how you wish to proceed:

  • Audit current configuration:
    o Operating Systems (OS)
    o Shares/permissions
    o Database access – SQL/Windows authentication group
  • Consider Scuba services (where applicable):
    o Closedown service
    o Import to Scuba5
    o InterCentreLinkService
    o ScubaExtDataSyncService
    Services can be located in windows\system32 or Syswow64 depending on the server OS
  • Consider web services (where applicable):
    o ScubaConnect.php within the WSDL folder holds the connection details
    o ScubaRemoteWebCamera routines for terminal server installation
  • Consider Sentinel:
    o Fixed IP settings for door controllers and PC(s) running Sentinel. Windows Firewall needs port 9100 opened

Suggested action plan:
1. Make a copy of the Live database (and potentially central folders) on the new server
2. Configure your existing Scuba clients with an additional ‘location’ connecting to the new database / folders (remembering to change the location name!)
3. Test and then set the clients back to the Live system
4. On the day of migration, reconfigure all clients to the new location
5. Back up the live database and then take off line
6. Restore the database on the new server (Central Folders may need to be moved again if they have changed in the interim period)
7. Allow end users access to the system
8. Remove old locations from client machines

To summarise, there are two options available:

  • Continue with SQL Server 2008 (not recommended)
  • Migrate to a current version (recommended)

If you have any questions, please contact Neville or Paul at Delta on 01825 768188 or via support@deltacomputerservices.co.uk

matt

Author matt

More posts by matt

Leave a Reply