LNDB Patch 1.2
Updated: 06-12-2015

  1. Updated LNDB to support import, export, and display of Unicode strings with all supported databases.
  2. Added support for inserting timestamps with subsecond resolution into MySQL (MySQL server version 5.6.4 and higher).
  3. Enhancements to DBImport to support the import of data files into new database tables. Previously, DBImport could only import data into existing tables (tables generated by the LNDB Engine through an LNDB/LoggerNet connection).
  4. We discovered that DBExport was considerably slower (2-3 times) than previous versions. This was caused by a change in the underlying Delphi database code, and was out of our control. We decided to port DBExport (and several custom controls and dialog windows) from Delphi to C#. This resulted in a significant performance increase of DBExport.
  5. Cosmetic updates for the CR6, CRVWx, and CRS45x.
  6. Fixed some issues that caused the automatic archival of tables to fail on Windows Azure.
  7. A fair amount of testing was done to identify the necessary steps a user must take in order to safely migrate their MySQL non-UTF8 encoded tables to UTF8 encoded tables. Detailed documentation was written and made available in the help and PDF manual. We also added a new dialog in LNDB Manager that assists the user in converting their non-UTF8 encoded MySQL tables to UTF8 encoded tables.
  8. Previously, a change in a column’s units or process required the table to be manually archived if the user chose to stop storing data when table definitions changed. An option was added to allow the meta tables to be updated, and storage to continue without an archive.
  9. Verified LNDB's compatibility with all new versions of SQL Server, SQL Server Compact, and MySQL since LNDB 1.1 was released. This includes SQL Server 2012 and 2014. SQL Server Compact SP2, and all new MySQL versions greater than version 5.1.
  10. Testing of LNDB against a Windows Azure (hosted) SQL database, as well as LNDB running on a Windows Azure virtual machine. We verified that LNDB works well in a hosted environment, at least on the Azure platform.
  11. The LNDB dependency on the .NET framework has been updated from .NET 3.5 to .NET 4.0.
  12. Updated the LNDB to install the SQL Server Compact SP2 framework.