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.