New Microsoft SQL Server Platform
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?
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
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.
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?
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
- 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.
Need Help Upgrading?
If you aren't already working with a Sage support provider, use the button below to find a Sage partner in your area.