LMSR SQL Mirroring for ReportFYI

LMSR SQL Mirroring for ReportFYI (formerly Renovofyi) 

SQL Mirroring for ReportFYI (formerly Renovofyi)  allows the user to select Sage 100 G/L and System 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.

This product is designed to work in conjunction with ReportFYI and only allows mirroring of G/L and System Files so that ReportFYI can access the data in SQL.  The following files should be mirrored for ReportFYI to properly access the data:

  •  SY_Company (System Data)
  • GL_Account
  • GL_AccountStructure
  • GL_Budget
  • GL_DetailPosting
  • GL_FiscalYearDetail
  • GL_MainAccount
  • GL_PeriodBudgetDetail
  • GL_PeriodPosting History
  • GL_Subaccount

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.