Monday, August 24, 2009

SQL Server Operating System: Pros and cons of FREE

In most cases, you need a SQL server operating system on your server. This might be included with your new server purchase, or you may need to purchase it separately.
Keep in mind that you need the same number of SQL licenses as you have accounting software user licenses.

We recommend that you budget to buy a few additional SQL licenses because some reporting tools in your accounting sys-tem will require a SQL license too.

Many people ask about the free version of SQL called MSDE. This may be an option, but you should know that MSDE has two limitations.

1. First, there is a data size limitation based on your transaction volume in the accounting system. There is no magic formula to determine how much space you will need for your system.

An experienced Partner should help you deter-mine what database size will work for your unique situation.

2. Second, there is a lack of administrative mainte-nance tools for MSDE. If you have a problem with the MSDE database, it can be harder to fix, and you know what that means – more support costs.

TO SAVE :
You can always start with the free MSDE version of SQL to minimize upfront costs, and upgrade to the full version of SQL later.

No comments:

Post a Comment