What is the best option for a local light-weight database
Question
Wednesday, August 12, 2015 11:37 PM
Hi, what is the best option for a local database - I mean only one application needs to access it within one PC?
I used SQL CE a lot and have had no problem, but not knowing why Visual Studio 2013 and 2015 have stopped supporting it.
I also know SQL Lite and LocalDB.
What is the best option, that is free, simple to deploy, light, and have a good future?
All replies (6)
Thursday, August 13, 2015 6:04 AM ✅Answered
Good day silly_dude
You can basically use almost any embedded database if you want. An embedded database is a database that aimed to be installed as part of your own application. In most cases in order to do so, the embedded database is a simple application that you just attach to your application, and it can work directly without any installation.
* SQL Server Compact is a free SQL Server embedded database, that you can check.
* SQLite is probably one of the most common embedded database and can be used directly. There is even an small version that work as portableapps (you can have it on external disk or diskonkey): http://portableapps.com/apps/development/sqlite_database_browser_portable
| Ronen Ariely [Personal Site] [Blog] [Facebook] |
Thursday, August 13, 2015 6:38 AM ✅Answered
but not knowing why Visual Studio 2013 and 2015 have stopped supporting it.
Just a note: Only the tools for SQL CE have been removed from Visual Studio, but you still can use it in your projects. To manage/design CE databases you can use the free & great tool SQL Server Compact/SQLite Toolbox , available as stand-alone app and as a VS plugin.
Olaf Helper
Wednesday, August 12, 2015 11:46 PM
How about SQL Express from Microsoft?
http://www.microsoft.com/en-us/download/details.aspx?id=42299
You'll also need the Management Studio
http://www.microsoft.com/en-US/download/details.aspx?id=8961
Wednesday, August 12, 2015 11:48 PM
But SQL Express requires a lengthy and heavy installation - almost the same process of installing the full version of SQL Server. In comparison, SQL CE only needs a runtime install.
Wednesday, August 12, 2015 11:53 PM
But SQL Express requires a lengthy and heavy installation - almost the same process of installing the full version of SQL Server. In comparison, SQL CE only needs a runtime install.
Then MySQL?
For a local database, and I know what most will say, however MS-Access is a great option. I have had excellent luck with it, except for when MS removed DBF Import/Export functions.
I use MS-Access every day to process text, excel, XML, and DBF files from customer. Most of what I do is a one time use of data then done.
I create master templates with queries, and run through VB.
Thursday, August 13, 2015 4:03 AM
You can encapsulate SQL Server EXPRESS installation into the Application setup. It is pretty easy and works just fine
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence