Sage 100

A few quick thoughts:

• SQL is not free.  (SQL Express is not supported, and all other versions have a cost).
• IMHO, the primary benefits of SQL are data security and speed of custom reports.
• Otherwise, Premium performance is similar to Advanced for most circumstances (as long as there is a high-speed / low latency connection between the Sage service and SQL).

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

This led me to believe that you could use SQL Express, but perhaps SQL Express is not the same thing as SQL Run Time Version.   

I missed the 'if you purchased SQL Server'.. the first time I read this...

Microsoft SQL Server Runtime Edition

If you purchased SQL Server directly from Sage, you will install Microsoft SQL Server Runtime Edition. The only difference between this version and the standard edition of SQL Server is that Microsoft SQL Server Runtime Edition can be used only with Sage products. The performance of the two versions is the same, both come with the same database administration tools, and neither have restrictions on the database size.

From <https://help-sage100.na.sage.com/InstallGuide/2023/Content/InstallGuide/Install_Premium.htm#08install200sql_861675170_59813>

A few quick thoughts:

• SQL is not free.  (SQL Express is not supported, and all other versions have a cost).
• IMHO, the primary benefits of SQL are data security and speed of custom reports.
• Otherwise, Premium performance is similar to Advanced for most circumstances (as long as there is a high-speed / low latency connection between the Sage service and SQL).

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON

I have a Premium FAQ, which I created to share with my more technical customers. The issue I kept running into was that customers would want more info, and they'd call Sage, and then they'd come back more confused than before they called. 

Sage 100 Premium & Microsoft SQL FAQ

thank you, very helpful

I have a Premium FAQ, which I created to share with my more technical customers. The issue I kept running into was that customers would want more info, and they'd call Sage, and then they'd come back more confused than before they called. 

Sage 100 Premium & Microsoft SQL FAQ

Great document @Wayne Schulz!

thank you, very helpful

I have a Premium FAQ, which I created to share with my more technical customers. The issue I kept running into was that customers would want more info, and they'd call Sage, and then they'd come back more confused than before they called. 

Sage 100 Premium & Microsoft SQL FAQ

@Wayne Schulz - Gem of a document.  I wish I had been aware of it before doing my first ADV migration to SQL.  Needless to say, there was a learning curve.  My biggest gotcha was dealing with the migration of Sage Intelligence reports.  Not easy to do with the database change.  If your ADV user has SI, factor this hidden cost into the "FREE" upgrade costs.  Also, the Doclink for the FREE software change was very spendy.  At the end of the day, the IT department has a more secure database and the users have faster reporting capabilities.

Great document @Wayne Schulz!

thank you, very helpful

I have a Premium FAQ, which I created to share with my more technical customers. The issue I kept running into was that customers would want more info, and they'd call Sage, and then they'd come back more confused than before they called. 

Sage 100 Premium & Microsoft SQL FAQ

@Wayne Schulz - Gem of a document.  I wish I had been aware of it before doing my first ADV migration to SQL.  Needless to say, there was a learning curve.  My biggest gotcha was dealing with the migration of Sage Intelligence reports.  Not easy to do with the database change.  If your ADV user has SI, factor this hidden cost into the "FREE" upgrade costs.  Also, the Doclink for the FREE software change was very spendy.  At the end of the day, the IT department has a more secure database and the users have faster reporting capabilities.

Great document @Wayne Schulz!

thank you, very helpful

I have a Premium FAQ, which I created to share with my more technical customers. The issue I kept running into was that customers would want more info, and they'd call Sage, and then they'd come back more confused than before they called. 

Sage 100 Premium & Microsoft SQL FAQ

They do have SI, but just a couple simple reports.  Do they need to buy an extra connector or just a pain to redo connecting them?

@Wayne Schulz - Gem of a document.  I wish I had been aware of it before doing my first ADV migration to SQL.  Needless to say, there was a learning curve.  My biggest gotcha was dealing with the migration of Sage Intelligence reports.  Not easy to do with the database change.  If your ADV user has SI, factor this hidden cost into the "FREE" upgrade costs.  Also, the Doclink for the FREE software change was very spendy.  At the end of the day, the IT department has a more secure database and the users have faster reporting capabilities.

Great document @Wayne Schulz!

thank you, very helpful

I have a Premium FAQ, which I created to share with my more technical customers. The issue I kept running into was that customers would want more info, and they'd call Sage, and then they'd come back more confused than before they called. 

Sage 100 Premium & Microsoft SQL FAQ

Jeff can add his experience with SI, which is likely more recent than mine. I'm a novice with SI, and all I can recall doing was exporting and importing the reports, and then they worked. I don't think I had to do any significant re-writing, though the customer I worked with had almost all GL-based reporting.

They do have SI, but just a couple simple reports.  Do they need to buy an extra connector or just a pain to redo connecting them?

@Wayne Schulz - Gem of a document.  I wish I had been aware of it before doing my first ADV migration to SQL.  Needless to say, there was a learning curve.  My biggest gotcha was dealing with the migration of Sage Intelligence reports.  Not easy to do with the database change.  If your ADV user has SI, factor this hidden cost into the "FREE" upgrade costs.  Also, the Doclink for the FREE software change was very spendy.  At the end of the day, the IT department has a more secure database and the users have faster reporting capabilities.

Great document @Wayne Schulz!

thank you, very helpful

I have a Premium FAQ, which I created to share with my more technical customers. The issue I kept running into was that customers would want more info, and they'd call Sage, and then they'd come back more confused than before they called. 

Sage 100 Premium & Microsoft SQL FAQ

No need to purchase connectors.  I have been told by my SI expert that the official stance from Sage is that SI in Premium is not supported.  I have not verified that with any Sage article.  He has developed a way to migrate them but it is time-consuming.  A handful of reports isn't too bad, but it does add up.

Jeff can add his experience with SI, which is likely more recent than mine. I'm a novice with SI, and all I can recall doing was exporting and importing the reports, and then they worked. I don't think I had to do any significant re-writing, though the customer I worked with had almost all GL-based reporting.

They do have SI, but just a couple simple reports.  Do they need to buy an extra connector or just a pain to redo connecting them?

@Wayne Schulz - Gem of a document.  I wish I had been aware of it before doing my first ADV migration to SQL.  Needless to say, there was a learning curve.  My biggest gotcha was dealing with the migration of Sage Intelligence reports.  Not easy to do with the database change.  If your ADV user has SI, factor this hidden cost into the "FREE" upgrade costs.  Also, the Doclink for the FREE software change was very spendy.  At the end of the day, the IT department has a more secure database and the users have faster reporting capabilities.

Great document @Wayne Schulz!

thank you, very helpful

I have a Premium FAQ, which I created to share with my more technical customers. The issue I kept running into was that customers would want more info, and they'd call Sage, and then they'd come back more confused than before they called. 

Sage 100 Premium & Microsoft SQL FAQ