Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Contact

How To Move Sage 100 Premium ( SQL ) To A New SQL Server

November 29, 2021 by Wayne Schulz

There may be a time when you need to move your Sage 100 database from one SQL server to another without also moving the server that the core Sage 100 is installed to.

Fortunately, this is not a big project. Sage has documented the steps in their knowledgebase.

What you’ll need to do is create MAS_USER and MAS_REPORTS on the new SQL server, backup and restore the data to the new server from the old server and then run a Sage utility to point Sage 100 to the new SQL Server location.

Follow this link to the Sage knowledge base for the details on how to move your Sage 100 SQL server database from one SQL server to another SQL server while keeping Sage 100 Premium installed to the same underlying server.

Sage 100 Premium ( aka SQL ) is available as a no-cost upgrade from most users who are on Sage 100 subscription. The migration from Standard or Advanced is well documented. The primary benefits of using a SQL database with Sage 100 are (a) security over data tables ( which are all protected by SQL security ) and (b) significantly faster external reporting ( your standard Sage 100 reports on the menus will typically be about the same speed but anything attached directly to the SQL database will report much quicker).

If you’ve been pondering a move from Sage 100 Standard or Advanced to Sage 100 Premium ( SQL ) then you may wish to review my Sage 100 Premium FAQ which outlines in more detail the pros and cons of using a SQL database attached to Sage 100.

Share this:

  • Twitter
  • Facebook
  • Email
  • LinkedIn

Filed Under: Sage 100 Tagged With: sage 100 premium, sql

Secure cloud hosting for Sage 100
Call 1-888-244-6559 (toll-free)

About Wayne Schulz

Wayne Schulz is a Sage 100 Consultant located in Connecticut. He has worked with Sage 100 since 1986 and provides advanced support to companies located 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 860-657-8544.

Access Sage 100 in the cloud today. 3rd party applications supported Available 24/7 from anywhere. Dedicated hosts

Call 1-888-244-6559 (toll-free)

Search Our Site

Sage 100 Newsletter

Sage 100 News

  • Sage 100 Updates for 2023: The Year-End Edition You Can’t Afford to Miss
  • Summit Hosting Rebrands as Summit
  • Does Sage have plans to stop supporting TLS 1.0 & 1.1 for Sage 100?
  • Payroll Requirements for Year-End 2023
  • DataSelf ETL+ v2023.07 for Sage 100 Announced
  • Version History of Sage 100 Accounting Software
  • What Happens if Sage 100 Goes Read-Only?
  • Sage 100 Knowledgebase Updated
  • Top Sage 100 New Features – Versions 4.4 through 2023
  • The Wayfair Ruling at Five: Why 72% of Businesses Still Struggle with Economic Nexus

Contact Us

Schulz Consulting
Connecticut Office
Click Here To Contact Schulz Consulting
Phone: 860-657-8544
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

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

sage 100 email newsletter
Schulz Says Email NewsletterSent Thursday by 1pm

Join our Sage 100 email newsletter.

  • Sent weekly each Thursday 
  • Over 1,500 subscribers
  • No spam - leave anytime
  • Learn about pending updates, fixes, popular integrations
Become a Member

Never see this message again.