What’s a Sage Accpac ERP System Database?
Posted by Scott Davies on Fri, Jun 11, 2010 @ 03:26 PM
Think way, way back to when you setup your first company in Sage Accpac ERP. (Ok, it may not be that far back for some of you.) If you recall, you actually created TWO databases – a Company and a System Database. A Company Database is fairly self explanatory, but a System Database? What is it and why do you need one?
A System Database contains information such as Currencies and Rates; Optional Field definitions; Schedules and Reminders; User Authorizations; and Customization information. Since there is a high likelihood that this information would be common across many, if not all, of your companies, they are grouped together into a common “System” Database that can be used over and over again.
So how does structuring the database in this fashion benefit you? Let’s say tomorrow you decide to create a new company in Accpac; you don’t have to re-enter all of your users*, currencies and rates, etc. Just link the new company’s database to your existing System Database. If you forgive the database-design terminology, the relationship between System and Company Databases in Accpac is one-to-many.
It is no mere coincidence, as you may have deduced, that much of the information in this common System Database is available in Accpac's System Manager under the “Common” Services area. Also tied to the System Database are the functions in the Administrative Services module. However, the functions in Common Services are slightly different – as they can not only be common across multiple companies, but also across the different modules within each company.
It is important to note that when backing up your Accpac ERP database (be it Pervasive or MS-SQL) you need to back up BOTH your Company and System Databases. A Company Database will not load without a System Database.
If you have any questions about your System Database, backup routine, or any other Accpac ERP related questions, please don’t hesitate to call our offices. We’re here to help!
* The master users list is not actually stored in the System Database but, rather, in a directory under your Accpac Shared Data folder.