Sage 100 Upgrade to MS SQL - Seeking Feedback

Posted By Frank Fromm over 5 years ago

We are looking at upgrading our Sage 100 back end to use Microsoft SQL. We have been told it shouldn't be an issue but others have a perception that Sage 100 on MS SQL is slow.

Is this true still? I think the information is old as I cannot imagine that Sage would let this product persist with that sort of performance issue

We have a reseller that we have and they stated it should be fine - but their opinions to what others have gone through can be night and day.

thank you

Frank

Parents

0 Kevin M over 5 years ago

Only with massive bulk transactions (importing 1000 of lines, posting 100's of invoices at once...) will you really notice any difference, and even then, throwing better hardware at the problem would help with that.

Custom reporting is phenomenally faster with SQL.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Kevin M over 5 years ago

Only with massive bulk transactions (importing 1000 of lines, posting 100's of invoices at once...) will you really notice any difference, and even then, throwing better hardware at the problem would help with that.

Custom reporting is phenomenally faster with SQL.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 Frank Fromm over 5 years ago in reply to Kevin M

That's where the conversation started - i am building an SSRS solution by pulling data using OpenQuery in stored procedures. The issue came when they wanted financials in more real time. I don't want to keep pulling data from Sage 100 .
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Sage 100 Upgrade to MS SQL - Seeking Feedback

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING