Would you like to have the advantage of the significant performance improvement offered by SQL data tables? Well you can with an enhancement for Sage MAS 90 or 200 that mirrors your data tables into SQL in real time.
SQL Mirroring for Sage MAS 90 and MAS 200 product that DSD Business Systems has offered for the past few years that they were demonstrating at Insights 2009.
From DSD Business Systems’ Product Page:
SQL Mirroring allows a user (version 4.05 to 4.30) to choose which Sage MAS 90 and Sage MAS 200 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 MAS 90 and Sage MAS 200 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 MAS90.
We’ve used this at a client who mirrored some large MAS 90 tables and the setup was easy (about 30 minutes tops) and once running the process is seamless with the tables mirroring in the background with no intervention on the users part.
Naturally reporting off the SQL tables is lightning fast and as noted in the product description any of the framework modules can have their Crystal Reports take advantage of SQL Mirroring.