What database software is typically used when Windows is the operating system?

Answer 1

There are many databases (Database server) solutions available for the Windows Operating system. The choice made is depending about many factors; such as: Scalability requirements Intellectual capital within the firm (Which produce the IT people know how to work with). Existing system platforms being used Capital available for building and maintaining a solution Some examples of database solutions would be: (Commercial Solutions) Microsoft SQL Server Oracle Microsoft Access (Open Source Solutions) MySQL Postgress SQL More about the solutions available: Microsoft SQL This is the most popular solutions. MS SQL is idea in most all situations however Oracle has a scale advantage in VERY heavy transaction environments where millions of records will be inserted on an ongoing basis. MS SQL server has a free desktop version as well as various licensed models to fit a wide spectrum of installation needs; which includes clustering, etc. Oracle Oracle is known to be a very expensive solution and is typically installed in very large installations. Additionally Oracle is often selected in a MIXED OS environment. As an example a firm may have some Unix Oracle installations and Windows OS installations. (The free alternatives) MySQL MySQL as come a long way however it is still not truly a database engine on the backside. MySQL is more a flat data stored with an interface program (not a server based product) that allows for the accessing of the data through SQL program code. Some will argue that MySQL is very good while most SQL programmers would strongly advice against it. This is not a debate that we will enter into here. MySQL has been around for a long time and independent programmers and small software companies have implemented it successfully. MySQL is closest to MSSQL in its SQL language deployment. This being said it is a viable option for a SQL deployment however popular opinion might suggest other routes. PostGress SQL is often related to Oracle in its SQL language deployment (more like Oracle than MSSQL). While I do not have hands on experience with Oracle OR PostGress my understanding from highly trusted resources is that PostGress is a very strong open source option. Postgress is stable, adheres to ANSI SQL standards and is a true database engine. Given my limited knowledge on Postgress and Oracle overall I would say that Postgress is a strong alternative however research should be done to insure that this is the right option for you. Postgress SQL is another free