It has been a very busy few weeks working on Geocortex Optimizer. One of the nice things about working with a small project team is that individually, you get exposure to a wide range of technologies that you might otherwise not get to use. For example, over the last few weeks, I’ve worked with .Net Remoting, WIX installers, Microsoft SQL Server 3.5 Compact Edition, ASP.NET, and Microsoft AJAX. It’s pretty cool. My skill set is growing and happily, I am no longer an out-of-date, middle-aged software developer.
This week’s big discovery was Microsoft SQL Server Compact Edition. For those of you not familiar with it, SQL Server Compact Edition is the “in process” SQL Server engine that targets the desktop application and mobile markets. As far as I can tell, it is a surprisingly complete SQL engine that runs within your application and provides similar performance and capacity to Microsoft SQL Server Express. You can even open its database files using the SQL Server Management Studio. The best part is, it is free for distribution, very easy to install, is really small and uses the same T-SQL that SQL Server uses which provides a straight-forward upgrade path for those users with more advanced needs. There are a few things missing that you may or may not miss including stored procedures and triggers but my guess is that the majority of desktop applications, where the focus is not the database, will not even notice.
Check it out. You’ll be glad you did.
At work with sql files i usually use next software-sql server database repair,tool is free as far as i know,it repair data from corrupted databases in the MS SQL Server format (files with the *.mdf extension),supports data extraction via the local area network,can save recovered data as SQL scripts, it is also possible to split data into files of any size,compatible with all supported versions of Microsoft Windows, such as Windows 98, Windows Me, Windows NT 4.0, Windows 2000, Windows XP, Windows XP SP2, Windows 2003 Server, Windows Vista,tool supports the following database formats: Microsoft SQL Server 7.0, 2000, 2005,also can repair .mdf files of Microsoft SQL Server 2005, repair mdf file of Microsoft SQL Server 2005 (64-bit).
I have thoroughly used Sqlite in the past, it is complete, but lacks speed and has bugs, I discovered that Sqlite can’t be used by even 3 Users doing long database operations at the same time. It just locks up. Now only yesterday, I finally realized and was shocked that Sql Server Compact Edition is a hidden magic tool, does all the things i dreamt of. Sql Server Compact Edition 3.5 is the best Embedded Database that you will ever find in the entire world. It is free! No bugs came ever with my handling of Sql CE.
Tushar
[...] [...]