Is All Your Data Slowing You Down

For some of you, you have been using the same accounting system for awhile. The good news is that you have years of historical data to draw upon for everything from measuring your company to negotiating vendor contracts to finding the product that Bob purchased five years ago. The bad news is you have to wade through years of transactions to get to the current data. A lot of data can slow down not only your searches for information, but overall system performance.

Wouldn't it be great if you could have the best of both worlds?

You can.

Consider this: Other than trending reports and the rare ad hoc lookups, you use only the current fiscal year and the prior year or two for most of your day to day functions.

An option for handling this situation is to make a copy of the current database for your company and use the copy as an "archive" company.

* Since this "archive" company will be a real accounting system company, it can be accessed as needed. You will simply log into this "archive" company and look for the data you need.
* The security for this company can be set as read-only so users will not be able to change any data.
* Software tools such as FRx, SQL Server Reporting Services, and Crystal Reports can make reports that combine the data for seamless reporting.

Once you have all your data archived, we are free to remove history in your current company using the accounting system's transaction history removal tools.

Next Steps

Creating an "archive" company requires significant accounting system and SQL Server knowledge and experience. Omnios professional consultants can assist you with planning the archival and implementing the change.