Friday, March 23, 2012

liteweight Sql server edition

Hello all,

This might not be the right place to ask this but i'll give it a try. I don't know if anyone here is familliar with Firebird 2.0 Embedded server. This an embedded database server based on the firebird architecture. Basically it works with you executable, a dll file and the database file (*.gds). The dll is then loaded in memory and acts as your local firebird server.

I am looking for something like that, based on the sql server 2005 plarform. I'm familliar with the express edition, but i would have to install the express edition on the client machine in my case. The database will be used for a kind of heavy standalone application to do datastorage in etc.

I guess I could use access but I don't want that. Can anyone point out to me what my best approach would be?

Thanks!

It sounds like SQL Server Express is what you want. If Access is not enough, and you don't want the licensing fees of full-blown SQL Server, then Express will work (and it can be distributed with your app). There are other free and/or open source databases out there.

|||

DarrellNorton:

... (and it can be distributed with your app) ...

thats good. I'll figure how to do that, but basically you're saying that when my app is being installed, I can have sql express installed also (together with the db)?

|||

Microsoft have put a fair bit of effort into making it easy to embed sql express into the installation routine for your application. You have a few choices - here is a fairly lengthy article from MSDN on the subject: http://msdn2.microsoft.com/en-us/library/bb264562.aspx. If you need something a bit shorter and to-the-point, have a look on the Four Guys from Rolla website, I'm sure I've seen a quick guide there.

sql

No comments:

Post a Comment