For the past couple of weeks we have been testing some major changes to the underlying database access framework that Terian ID Creator uses.
This is a considerable update and the information below may be subject to change.
Overhaul Driver:
The primary driver (pardon the pun) behind this change has been to migrate to FireDAC as it is intended to become the replacement for the venerable dbExpress (DBX) data access library which in time will most likely become deprecated. The secondary driver was the desire to remove the SQL Server 2008 R2 Native Client prerequisite, as having an almost 10 year old application installation as a prerequisite is not necessarily the best look when installing software.
So we have updated the native client prerequisite to SQL Server 2012 Native Client, which is the latest available from Microsoft with their future support moving towards the ODBC Driver which supports a more diverse set of operating systems.
Database Support:
The plan at this stage is for Terian ID Creator to support both the SQL Server 2012 Native Client and the newer Microsoft ODBC Driver 13 for SQL Server. This will provide support for the following versions of SQL Server:
- SQL Server 2008
- SQL Server 2008 R2
- SQL Server 2012
- SQL Server 2014
- SQL Server 2016
Officially Terian ID Creator will only support SQL Server 2012, 2014, and 2016. Other versions may work, however they will not be tested or supported.
Operating System Support:
The change to the data access drivers also in turn means support for versions of Windows prior to 7 have also been dropped. The following operating systems will be supported in v1.30:
- Microsoft Windows 7
- Microsoft Windows 7 SP1
- Microsoft Windows 8
- Microsoft Windows 8.1
- Microsoft Windows 10
Similarly to the database server support, other versions of Windows may work, however they will not be tested or supported.
We are very early in the testing phase, and it is likely some additional changes will be made in turn leading to more testing, so we have no expected release date, however as we progress we will keep you updated.