Wanted to find suitable local table storage for some quick data transformation engine. Didn't want to use tempdb or create\drop tables in my SQL Server DB.
SQLite.org:
Pros: just one dll, no install needed
Cons:
No Foreign Keys. Write locks the whole DB
SQL Server Compact Edition (CE) 4.0:
http://weblogs.asp.net/scottgu/archive/2011/01/11/vs-2010-sp1-and-sql-ce.aspx
http://www.microsoft.com/download/en/details.aspx?id=17876
Toolbox: http://sqlcetoolbox.codeplex.com/
works in a multi-threaded environment. Previous releases of SQL CE only worked in client-apps and could corrupt/crash in server environments. SQL CE 4 specifically supports server scenarios.
in-process; transactions; no XQuery or XML support; no SPs; DB size - .sdf file up to 4Gb
Management UI: VS2010 IDE, SQL Server Management Studio
Needs Visual C++ 2008 Runtime Libraries - installed with .Net 3.5 SP1
need to install tools for VS2010SP1 : http://go.microsoft.com/fwlink/?LinkId=212219
Other alternatives (to be continued):
http://www.firebirdsql.org/
SQLite.org:
Pros: just one dll, no install needed
Cons:
No Foreign Keys. Write locks the whole DB
SQL Server Compact Edition (CE) 4.0:
http://weblogs.asp.net/scottgu/archive/2011/01/11/vs-2010-sp1-and-sql-ce.aspx
http://www.microsoft.com/download/en/details.aspx?id=17876
Toolbox: http://sqlcetoolbox.codeplex.com/
works in a multi-threaded environment. Previous releases of SQL CE only worked in client-apps and could corrupt/crash in server environments. SQL CE 4 specifically supports server scenarios.
in-process; transactions; no XQuery or XML support; no SPs; DB size - .sdf file up to 4Gb
Management UI: VS2010 IDE, SQL Server Management Studio
Needs Visual C++ 2008 Runtime Libraries - installed with .Net 3.5 SP1
need to install tools for VS2010SP1 : http://go.microsoft.com/fwlink/?LinkId=212219
Other alternatives (to be continued):
http://www.firebirdsql.org/
No comments:
Post a Comment