Embedded Database

Feb 20, 2008 at 1:37 AM
Dear Sir/Ma'am:

I read your home page description and you mentioned that you didn't like SQL Mobile. I'm not sure what that is exactly but I would highly recommend Microsoft's SQL CE v3.0 or v3.5 depending on your needs. It's great!

There are others as well if you want those. But nothing beats the SQL CE product (it's free!).

- Joshua
Coordinator
Feb 21, 2008 at 5:45 AM
Thanks for the idea. The trick is to find a database engine that does not need to be installed seperately. I need something that can be embedded into the actual application. The application needs to be deployed on a computer that is locked down by the system admin and does not allow new items to be installed without explicit permission.

I think that the solution may lie in using XML to store databse information since I think the answer may lie in Xquery and XPath but I am not familiar with these technologies as yet.
Feb 21, 2008 at 6:18 PM
I think you should read the documentation on SQL CE. It is an integrated database.. all you do is include a couple DLL's with your app and that's it. There is nothing else to install, configure, etc. It's really simple and will accomplish what you want.
Coordinator
Feb 21, 2008 at 11:54 PM


DatSure wrote:
I think you should read the documentation on SQL CE. It is an integrated database.. all you do is include a couple DLL's with your app and that's it. There is nothing else to install, configure, etc. It's really simple and will accomplish what you want.


Perhaps you can provide a couple links? When I google it I get links to SQL Server 2005 Mobile and SQL Server Compact which are included and used in my application. However if the plaform you run the application on does not have SQL Sever Express, Visual Studio 2005 or a license key it will not work.
Feb 22, 2008 at 1:03 AM
Malk0lm:

Sure, no problem. I think once you get into it you'll really like it!

First, I would recommend you go to: http://www.microsoft.com/sql/editions/compact/default.mspx and read everything there. There is also a link to download the latest bits. (Note that SQL CE 3.5 SP1 was released today!)

Once you've had enough of that site you can then go to the following:

1. http://msdn2.microsoft.com/en-us/sqlserver/bb219480.aspx - This page has great videos that will walk you step-by-step through how to use it and why you should use it.

2. http://msdn2.microsoft.com/en-us/virtuallabs/aa740409.aspx - This page has virtual labs where you can actual walk through a tutorial and really do it in real-time as you go!

3. http://www.microsoft.com/downloads/details.aspx?FamilyID=1ff0529a-eb1f-4044-b4b7-40b00710f7b7&displaylang=en Now that you know what it is, have it installed, watched the videos, and done the labs you'll definitley want to download the Online Book for it. That way you'll have a great reference as you work with it!

This should get you off to a GREAT start! Good luck!
Coordinator
Feb 22, 2008 at 3:55 AM
You know, now that I look at that I realized that I already downloaded and installe that. However, it looks like the latest version 3.5 is not compatiable with VS2005. The IDE of record for that version is 2008, and since I do not own 2008 that version isn't doing me any good, that is why I could not use it as a data source using the gui development tools in VS. So I will revert to the 3.1 version to see if it works better with my version of VS2005.

Hopefully the change of code from using SQL Server Mobile to SQL Server Compact will be quick.