Skip to content

Script to mirror data from Sage MAS 90 ERP to MS SQL Server

Notifications You must be signed in to change notification settings

maxrice/MAS90Mirror

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 

Repository files navigation

MAS90Mirror - basic PHP script to mirror data from Sage Software MAS 90/200 ERP to Microsoft SQL Server.

Here's how to setup:

1) Download + Install PHP on your server (php.net)

2) Create two system DSNs (make sure to use the 32 bit ODBC tool)
	-One using the MAS90 ProvideX driver connecting to your shared MAS90 folder; Name it whatever you like, but remember it, as you'll need to enter it in the PHP scripts
	-One using SQL Server connecting to your destination database

3) Create the tables that you want to mirror in SQL Server. You can use Crystal Reports designer to see the list of fields, as well as the required data type for each.

4) Make a copy of the import-template.php file for each table you want to mirror. It's best to rename it according to the table (ex: import-ar-customer.php)

5) Create a scheduled task to execute "php -f C:\Path_to_import_php_file.php". It's probably best to execute this during periods of low activity.

6) And you're done! This is a good temporary solution until you can upgrade to MAS 200 SQL and replicate the data instead of mirroring (http://www.sagemas.com/Products/Sage-ERP-MAS-200-SQL)

About

Script to mirror data from Sage MAS 90 ERP to MS SQL Server

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published