Click here to monitor SSC

Alternative to Ms sql server 2005 express edition

Last post 07-21-2011, 1:48 PM by SQLOnFire. 2 replies.
Sort Posts: Previous Next
  •  05-13-2010, 12:38 AM Post number 91074

    Alternative to Ms sql server 2005 express edition

    Hello Everyone,

    Our server hosting providers are saying that our web site is running slow because we are using ms sql server 2005 express edition which is a free edition and had only a capacity of handling up to 4 GB data.

    And our database which we are currently using is now having more than 4.5 GB.

    Hence they recommended us to go for a paid one that is specialized edition workgroup and gave us the following link http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx to go through the comparison.

    The hosting providers says that it will be around 4500 rupees per month for sql server. As we are a small firm and cant afford this much amount.

    Please suggest any alternate methods.

    Thanks,
    Pollard
  •  06-02-2010, 1:21 PM Post number 92870 in reply to post number 91074

    Re: Alternative to Ms sql server 2005 express edition

    Sympathies with the problem of cost. There are plenty of ways of slimming down the size of your datanbase by refactoring it. However, if you really have run out of ways of keeping it below the 4 Gig limit, then the most obvious choice is PostgreSQL. However, the syntax has quite a lot of differences from SQL Server, and this is going to cost a lot of effort to migrate the application.

    Can you split the database into logical parts that can be put on different SQL Express servers?


  •  07-21-2011, 1:48 PM Post number 102448 in reply to post number 91074

    Re: Alternative to Ms sql server 2005 express edition

    Use Ms sql server 2008 express edition, it has a 10GB db size limit.
View as RSS news feed in XML