Author Topic: SQL Mirroring  (Read 111 times)

0 Members and 1 Guest are viewing this topic.

John Spikowski

  • Posts: 52
SQL Mirroring
« on: June 21, 2021, 10:34:24 pm »
With the NEWS that DSD is retiring their SQL Mirroring solution as of the end of the year, I wanted to mention that I wrote a SQL mirroring solution for Sage 100 using the open source and free Postgres SQL 64 bit server and ScriptBasic.

DSD's recommendation is to upgrade to Sage 100 Premium. The  problem with Premium is all data access is via an ODBC emulation of ProvideX file I/O. What you gain in reporting speed being SQL native you lose in overall performance. Reading NOMADS screens via SQL is painfully slow as is other routine tasks like updating.

This is a screen shot of the SQL Mirroring package running on a Windows Server.



Features
  • Postgres SQL 64 bit server integration. (MS SQL Server coming soon)
  • Updating tables just takes a few seconds.
  • Multi-threaded - You can do selective on demand syncing while auto mode is running in a thread.
  • Setting up new tables just takes seconds and create the SQL tables from Sage 100 definitions directly.
  • Easy to use GUI front end that is intuitive to use.

SQL Mirroring sells for $1,250.00 and comes with installation and setup assistance. Updates are free for a year.

If you would like to see a live demo via a Team Viewer session, send me an e-mail or give me a call.

John Spikowski - JAR Productions LLC
e-mail@johnspikowski.com
360-941-0452

« Last Edit: June 22, 2021, 01:29:16 pm by John Spikowski »