Sage Partners
Connect on Twitter
  • Home
  • Find a Reseller
    • By Location >
      • U.S. Partners
      • Canada Partners
    • By Sage Product >
      • Sage ERP Partners >
        • Sage 50 Partners
        • Sage 100 Partners
        • Sage 300 Partners
        • Sage 500 Partners
        • Sage X3 Partners
        • Sage Intacct Partners
      • Sage Construction Partners >
        • Sage 100 Contractor (Partners)
        • Sage 300 Construction (Partners)
      • Other >
        • Sage CRM Partners
        • Sage HRMS Partners
        • MIP Fund Accounting
  • Sage Product Info
    • Sage 50
    • Sage 100 >
      • Sage 100 Tips & Tricks
      • Sage 100 System Requirements
    • Sage 300 >
      • Sage 300 Installation Guides
    • Sage Intacct
    • Sage 500
    • Sage X3
    • Sage Construction >
      • Sage 100 Contractor
      • Sage 300 Construction
      • Sage Estimating
    • Other Sage Products >
      • Sage Fixed Assets >
        • Sage Fixed Assets User Guides
      • Sage CRM
      • Sage HRMS >
        • Sage HRMS System Requirements
  • Sage Add Ons
  • Resources
    • Blog
    • Popular Articles
    • Buying Guides >
      • Inventory Management Tips
      • ERP Implementation Failure
  • Contact Us

Sage 100 Contractor Now on SQL Server

8/11/2016

0 Comments

 
Sage 100 Contractor SQL
​With the release of Sage 100 Contractor 2016, Sage announced that this powerful software for the construction industry now runs on the industry-leading Microsoft SQL Server database.  In this article, we’ll explain why this is probably one of the most important updates to Sage 100 Contractor in many years.
​

New Microsoft SQL Server Platform

​Although Sage 100 Contractor 2016 has the same look, feel, and functionality that you’re already familiar with, it’s new SQL Database structure provides tighter security and an up-to-date technology platform upon which to build future software releases.
 
A technology stalwart for a very long time now, Microsoft SQL Server is known for industry-leading security, flexibility, and performance.  One of the key strengths of SQL Server is that it can handle large amounts of data without a significant drop in performance. It also provides database administrators with a wide range of user and security options for protecting your data and preventing file corruption.
​

What Does It Mean for Sage 100 Contractor?

All technology jargon aside, what it means for Sage 100 Contractor is that the software is now faster, more secure, and "plays well" with other software applications. Not only does SQL Server handle more data and transaction volume without losing speed or performance as your company grows, Sage 100 Contractor will also communicate more effectively with external applications and databases that also run on SQL.
 
In short now that Sage 100 Contractor is in the “SQL Server Club”, you’ll experience faster performance, stronger security, better reporting, and an expanded list of 3rd party integration options.
​

New Database Administration Tool

As part of the SQL Server rollout, Sage 100 Contractor now provides a new and separate database administration tool designed to help you take advantage of the database features without having to be a Microsoft SQL Server expert. 
 
Sage has relocated many of the administrative utilities and functions from the main Sage 100 Contractor program and moved them into the new Database Administrative tool. If you’ve used earlier versions of Sage 100 Contractor, several of these tasks will already be familiar to you. For example, the process of creating and deleting a company, backing up and restoring files, and archiving company data are similar to what you’ve used in the past.  
 
But in the process, Sage also boosted many of these capabilities considerably so that now you can schedule maintenance and backup functions to keep your company databases in good order. The new Database Administration tool also includes a migration utility that Sage designed and tested extensively to ensure a smooth and painless transition from older versions of Sage 100 Contractor (non-SQL) to the new SQL version.
​Database and Administration Guide
The new Database Administration tool comes with its own help system and administration guide to acquaint you with its features and use. Click below to download this new guide.

What’s Required to Support SQL Server?

Sage 100 Contractor 2016 (aka Version 20.2) requires an instance/installation of Microsoft SQL Server.

You can download and use Microsoft SQL Express at no charge, or you can purchase the full version of Microsoft SQL Server.  Another option is to start with Microsoft SQL Express and then upgrade down the road to the full version of Microsoft SQL if needed.
 
When you first open the new Database Administration tool, the program tries to configure an instance of Microsoft SQL Server with optimal settings designed specifically for Sage 100 Contractor. If you do not already have Microsoft SQL Server installed, you can let the Database Administration tool download, install, and configure Microsoft SQL Express for you.
 
NOTE: Microsoft SQL Server may have minimum hardware, software, and system requirements that should be considered. Please check with a Sage 100 Contractor support provider if you need guidance or specs.
​

Upgrading to Sage 100 Contractor 2016

Installing Sage 100 Contractor 2016 and upgrading your data involves a few more steps than in previous versions because you need to install 2 additional components including:
 
  • Install the new Database Administration tool on the machine you will use as your server.
  • Create a SQL Server instance for Sage 100 Contractor.
 
Download the Quick Start Checklist and “Going Live” Checklist, both of which provide a guide to all the important steps you should complete in order to install and begin using version 2016.
IMPORTANT: You must be using Sage 100 Contractor Version 19.7 in order to migrate your company to Version 2016 (20.2). If you’re running an earlier version of Sage 100 Contractor, you must first upgrade your company data to version 19.7.

Need Help Upgrading?

If you need help upgrading or getting started with Sage 100 Contractor 2016, please be sure to get in touch with your Sage Authorized support provider.  

If you aren't already working with a Sage support provider,  use the button below to find a Sage partner in your area.
​
Find a Sage Partner
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    ARE YOU A SAGE PARTNER?

    Get Your Business Listed Here!

    Click below if you're interested in having your business listed in this online directory of Sage Partners.
    Get Started
    Sage Warehouse Management
    Scanforce WMS for Sage
    Sage Cloud Hosting
    Picture

    Popular Articles

    Big Bang Implementation vs Phased Approach
    (Pros, Cons)

    ---
    What's New in
    Sage 100 2022

    ---
    What's New in
    Sage 300 2023

    ---
    New Release:
    Sage Intacct 2022

    ---
    What Does ERP Stand For?
    ---
    Sage 100 System Requirements and installation Guide
    ---
    Sage 300 Installation Guide
    ---
    Sage 100 Tips & Tricks

©2022 Top-Sage-Resellers.com. All rights reserved. This material and content on this website may not be reproduced, displayed, modified or distributed without the express prior written permission of the copyright holder. This website is not owned, operated, affiliated with, or endorsed by Sage Software, Inc. or Sage Intacct, Inc. Sage, Sage logos, and Sage product names mentioned herein are registered trademarks or trademarks of Sage Software, Inc. and/or its affiliates. Other product names mentioned are trademarks of their respective owners.
Privacy Policy