Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Technical
    • Sage 100 New Features ( Brief )
  • Sage 100 Support

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:

  • Share on X (Opens in new window) X
  • Share on Facebook (Opens in new window) Facebook
  • Email a link to a friend (Opens in new window) Email
  • Share on LinkedIn (Opens in new window) 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-certified consultant based in Connecticut. He has worked with Sage 100 since 1986 and provides remote consulting to companies throughout the United States. He is a founding member of the 90 Minds Consulting Group. To discuss working with Schulz Consulting, start with the Sage 100 inquiry page. Information is reviewed before follow-up about fit and next steps; technical work is scoped and priced separately.

Sage 100 Newsletter

Search Our Site

Sage 100 News

  • How to Fix: Sage 100 Desktop Launcher Closes Immediately After Login (No Error)
  • How To Update Sage Intelligence Keys as Sage Moves Away From Unlimited Licenses
  • Get More From Your Sage 100 Partnership
  • Sage Future 2025 Preliminary Agenda Released
  • Upgrading Sage 100 to 64-bit: Avoid These Integration Pitfalls
  • What’s New in Sage 100 2024? ( Video )
  • Sage 100 Users: Conquer Minnesota’s New Sales Tax & Delivery Fee Headache-Free
  • Elevate Your Sage 100 Expertise with SchulzSays: The Ultimate Newsletter for Users and Consultants
  • How To Purge Cleared Bank Reconciliation Transactions in Sage 100
  • 10 Exciting New Features in Sage 100 2024

Contact Us

Schulz Consulting · Connecticut Office · Available remotely nationwide.

Contact Schulz ConsultingPhone: 860-657-8544Email Us

We are a local branch of DSD Business Systems Connecticut.

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

sage 100 email newsletter

Schulz Says Email Newsletter

Sent 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.