Schulz Consulting

Sage 100cloud Consulting

  • Home
  • Services
  • Contact

DSD Business Systems SQL Mirroring YouTube Demo

May 13, 2009 by Wayne Schulz

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.

Link – DSD Business Systems SQL Mirroring for Sage MAS 90 and 200

Share this:

  • Twitter
  • Facebook
  • Email
  • LinkedIn

Filed Under: MAS 90 Add Ons, Master Developers, Sage 100 ERP Tagged With: dsd business systems, jim woodhead, mas200, Sage 100 ERP, sql, SQL Mirroring, Wayne Schulz

About Wayne Schulz

Wayne Schulz is a Sage 100 Consultant located in Connecticut. He has worked with Sage 100 and Sage 100cloud ( Formerly Sage MAS 90 and MAS 200) since 1986 and provides advanced Sage 100 technical support to companies located in Connecticut, Massachusetts, Rhode Island, New York and throughout the United States. If you are experiencing an issue with Sage 100, and would like to schedule a support session - please request assistance here or call 833-724-3100.

Search Our Site

Sage 100cloud Latest News

  • WFH Tip For Sage 100: Go Paperless February 24, 2021
  • When is Sage 100 2021 Due for Release? February 19, 2021
  • Sage 100 Partner Cloud List of Supported ISVs as of January 2021 February 12, 2021
  • Sage 100 User Help Files and Table Layouts – Version 2018 – 2020 January 27, 2021
  • Expect Sage 100 1099-NEC Functionality in Purchase Order With These Updates In Spring 2021 January 18, 2021
  • What Are The Differences Between Sage 100 Perpetual and Subscription Licenses? January 11, 2021
  • Sage 100 Aatrix e-Filing Bug Erroneously Reports Bad SSN Matches for 2020 January 6, 2021
  • There is No Sage 100 IRD for 2020 January 6, 2021

Our sponsors

Contact Us

Schulz Consulting
Connecticut Office
Phone: 860.657-8544
Email Us
Locally serving all of Connecticut, Massachusetts, Rhode Island, Vermont,
New York, New Jersey. Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

Copyright © 2021 · Parallax Pro Theme on Genesis Framework · WordPress · Log in

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.