locked
Breaking the 4GB limit or an unlimited (size) SQL Express version RRS feed

  • Question

  • Hi,

    I've been working for quite some time with SQL Server and reached a point where a big decision has to be made. I'm in need for a "server-less" database like using SQL express DLL version but without the 4GB limit. All the additional features that exists in SQL Standard/Enterprise are not as important as the 4GB size issue and the company I work for is even willing to pay MS royalties (for each supplied copy) for such a version but the 4GB barrier must be broken somehow.

    There are other alternatives like VistaDB but I would like to save such options to the very end.

    Does anybody know if such a solution exists?

    Gilad.

     

    • Edited by Giladk Tuesday, April 6, 2010 3:57 PM typo
    Tuesday, April 6, 2010 3:57 PM

Answers

  • There are a number of alternatives. You say the "DLL version". Do you mean SQL Server Compact Edition? There are plans to lift the 4GB barrier but since the project to create a managed code version of the DBMS have been scrapped, I don't know the status of that change. HOWEVER, I would look for other ways to reduce the size of the database. For example, if you are storing BLOBs (Binary Large Objects) like pictures or documents in the database, it makes a lot of sense to move these into a folder system and put the path to the BLOB into the database. This works for either SQL Server Compact Edition or SQL Server Express Edition (or any edition for that matter). Another alternative is to use Filestream. This is supported in SQL Server Express. It permits you to (again) move the BLOBs to a DBMS-managed file hierarchy that's kept separate from the database.

    hth


    __________________________________________________________________
    William Vaughn
    Mentor, Consultant, Trainer, MVP
    http://betav.com
    http://betav.com/blog/billva
    http://www.hitchhikerguides.net

    “Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)”

    Please click the Mark as Answer button if a post solves your problem!

    • Proposed as answer by William Vaughn Wednesday, April 7, 2010 5:00 PM
    • Marked as answer by Giladk Thursday, April 8, 2010 11:03 AM
    Wednesday, April 7, 2010 5:00 PM

All replies

  • hi Gilad,

    AFAIK, no such a scenario exists in the SQL Server SKUs... the "royalties" you are willing to pay should be deserved to buy a standard edition of SQL Server..

    regards


    http://www.asql.biz - DbaMgr2k - DbaMgr and further SQL Tools
    • Proposed as answer by Chirag Shah Wednesday, April 7, 2010 4:41 PM
    Wednesday, April 7, 2010 4:36 PM
  • Another alternative I would suggest is to use SQL Azure....
    • Proposed as answer by Kalman Toth Wednesday, April 7, 2010 4:58 PM
    Wednesday, April 7, 2010 4:42 PM
  • Another alternative I would suggest is to use SQL Azure....
    Wednesday, April 7, 2010 4:42 PM
  • There are a number of alternatives. You say the "DLL version". Do you mean SQL Server Compact Edition? There are plans to lift the 4GB barrier but since the project to create a managed code version of the DBMS have been scrapped, I don't know the status of that change. HOWEVER, I would look for other ways to reduce the size of the database. For example, if you are storing BLOBs (Binary Large Objects) like pictures or documents in the database, it makes a lot of sense to move these into a folder system and put the path to the BLOB into the database. This works for either SQL Server Compact Edition or SQL Server Express Edition (or any edition for that matter). Another alternative is to use Filestream. This is supported in SQL Server Express. It permits you to (again) move the BLOBs to a DBMS-managed file hierarchy that's kept separate from the database.

    hth


    __________________________________________________________________
    William Vaughn
    Mentor, Consultant, Trainer, MVP
    http://betav.com
    http://betav.com/blog/billva
    http://www.hitchhikerguides.net

    “Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)”

    Please click the Mark as Answer button if a post solves your problem!

    • Proposed as answer by William Vaughn Wednesday, April 7, 2010 5:00 PM
    • Marked as answer by Giladk Thursday, April 8, 2010 11:03 AM
    Wednesday, April 7, 2010 5:00 PM
  • Thank you for your answer. Unfortunatly, there is no way I can shrink my database enough to fit in to 4GB. I have BLOB data in the database which I can migrate to data files but that is only 50% of the database. The database is around 20GB-30GB for 1 year of data and, some of the data is saved in a compressed BLOB in the database so even using SQL2008 compression won't do much. Usually there are up to 100 databases on a single computer.

    One of the considered solutions is to split a big database in to multiple 4GB databases but maintaining the data won't be so easy (queries over multiple databases...)

    I guess VistaDB or Firebird are the next step.

    Thursday, April 8, 2010 10:58 AM
  • If you're willing to pay for it then why not just use Workgroup or standard edition?
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Thursday, April 8, 2010 4:11 PM