LMSQ SQL Mirroring allows the user to choose which Sage 100 ERP Data files to be mirrored directly into a SQL Database in “Real Time” . This means as the records are added, updated, or removed from the native Providex Database, a live record will be mirrored to your chosen SQL Database.The user may use Crystal reports to report directly from the SQL database.
For Sage 100 ERP Form Printing, if the module is a “Business Framework” module, then the Crystal Work Files are mirrored to SQL automatically.
NOTE: The SQL Mirroring product only writes, removes, and updates the SQL Database, but doesn’t read from it. Therefore, if you use another application to write to the SQL Database, those changes will NOT be reflected back into Sage 100 ERP.
DSD SQL Mirroring End-of-Life / End-of-Support Notice
Please note: The final DSD SQL Mirroring (LMSQ and LMSR) version that will be released for Sage 100 will be version 2018 (6.00). Starting with version 2019, users will be expected to move to Sage 100 Premium as all modules will be in the business framework at that time. DSD Business Systems is still in the process of determining the specific End-of-Life and End-of-Support dates, and we will release this information as soon as it is available.