Free-of-charge MSDE Database Tools
Microsoft SQL Server Desktop Engine is an effective free-of-charge variant of many scripts maintenance of expansion of the open database. However, there are a number of clauses. First, MSDE technology is not completely free-of-charge. However purchase of the individual license for any product, on which MSDE is applied (for example, Microsoft Access), provides the right of free-of-charge further distribution of basic MSDE elements. It is possible to create the appendix and freely to distribute it among uncertain number of users. Secondly, technology Query Governor does not suppose an opportunity of MSDE scaling for maintenance of powerful database service. However for databases of the highest class the free-of-charge open technology, most likely, will not approach.
Product SQL Server Express will be completely free-of-charge, without any clauses. The only restriction will be impossibility to involve more than one physical processor. However, the opportunity to use several processors exists for an operational system, in which environment this product will function.
Great efficiency will be provided with a multiprocessing computer with the organization of hyper line processing providing additional logic processor, which SQL Server Express can use. The maximal size of a database is 4 MB, and the buffer pool of SQL Server memory is limited to 1 MB.
Can open databases provide a great scalability? Yes, but if you use the appendices demanding opportunities for processing behind the capacities of free-of-charge SQL Server Express version, you will have to pay to the manufacturer the facilities in databases with which you will work. However SQL Server Express can serve real and free of charge in huge number of small corporate databases.
It is possible to find scripts, in which the open technology is capable to do what MSDE or SQL Server Express cannot do. However, in most cases the user who can benefit by the free-of-charge open database, will find not less advantages in free-of-charge version of MSDE or SQL Server Express.
Many people count on the open databases, as they do not consider the free-of-charge version of Microsoft product as a real candidate. Of course this decision is not the best. There are variants when the open database provides more advantages. However it is sad, when the client interested in free-of-charge technology of database service, wrongly believes, that Microsoft company couldn't offered him anything.
Terms And Conditions Privacy Contact Us
|