About tuning up company databases
About upgrading company databases
About scheduling nightly maintenance
About managing Company Admins and SQL logins
About migrating your data from version 19.8
The Database Administration tool is intended for system and company administrators. You use it to set up and maintain your company databases and to manage communications with your Microsoft SQL Server instance.
If you have used earlier versions of Sage 100 Contractor, several of these tasks will be familiar to you. For example, Database Administration includes utilities for creating and deleting a company, backing up and restoring company files, and archiving company data that you used in previous Sage 100 Contractor versions.
Important! Use Database Administration, rather than SQL Management Studio®, to perform the database administration tasks listed below, even if you are an experienced SQL Server user. Besides handling all the database tasks that you are likely to perform in a typical Sage 100 Contractor system, Database Administration was designed to optimize your data for Sage 100 Contractor, for example, by keeping related data in expected locations and creating backups automatically before performing certain critical processes. In the rare event that you need to use SQL Management Studio® to perform a task that is not provided in Database Administration, you should contact Customer Support for assistance.
Database Administration includes the following database and company management utilities:
-
Create Company Based on Existing and Create Company create new Microsoft SQL Server databases.
-
Rename Company and Delete Company are convenient utilities for working with existing companies.
-
Deploy Sample Company helps you install and refresh the sample data that comes with Sage 100 Contractor.
-
Tune Up Company Databases performs various maintenance tasks to keep your database functioning efficiently.
-
Back Up Company Databases enables you to back up your data "on demand," whenever needed.
-
Restore Company from Backup restores a selected backed-up copy of your database.
-
Upgrade Company Databases enables you to upgrade your databases smoothly from an earlier version of Sage 100 Contractor (SQL).
-
Archive Company Data utilities enable you to archive data for your oldest fiscal year and you Payroll data.
-
Migrate Company Data and Migrate Custom Reports transfers your version 19.8 company data and custom reports to a new location for Microsoft SQL Server. Migrated files are located in shared folders under C:\Sage100Con\Company\[Company Name], organized using a folder structure similar to earlier versions.
-
Schedule Nightly Maintenance utilities enable you to schedule backup and maintenance operations for times when other users are not logged into the system. You can also select the number of consecutive backups to keep.
-
Company Admins/SQL Logins utilities enable you to set up or delete logins to the SQL Server database, and to designate a user as a company administrator for a specified Sage 100 Contractor company.
-
Server Management tools enable you to control the SQL Server instances you use with Sage 100 Contractor easily and efficiently. You can create a new instance on your computer, move companies to the new instance, and remove an instance you no longer need. You can also automatically configure a secure connection to enable approved remote users to send information to Sage 100 Contractor. If you use SQL Server Express, Database Administration will prompt you to upgrade your instance when a new, compatible SQL Server Express edition is available.
-
Advanced Settings lets you specify how long to keep history about database changes for each company, including details about changed records, such as the date and user ID of the employee made the change. Details older than the retention period you specify are cleared during nightly maintenance. (This history is maintained in separate audit tables, which you can query using SQL Server Management Studio.)
-
The Toolbox provides a variety of troubleshooting tools to help you track changes in your database, and to diagnose and fix certain types of problems.
-
Advanced SQL Server Settings includes convenient, sophisticated access and memory management controls for your SQL database.
The Database Administration help includes detailed information about these utilities and how to use them.