SQL Compact 3.5 SP1 – 2 new hotfixes released

The SQL Compact team has made 2 hotfixes for SQL Compact 3.5 SP1 x86 available. The 2 hotfixes fixes bugs first reported on the MSDN Forum, namely this and this thread.

The first fix, which updates SQL Compact to version 3.5.5692.1) is for an error with the SQL Compact Entity Framework support, resulting in the following error message: The ntext and image data types cannot be used in WHERE, HAVING, GROUP BY, ON, or IN clauses, except when these data types are used with the LIKE or IS NULL predicates.

The second fix (which I assume also includes the first fix, as it updates the SQL Compact version to 3.5.5692.2), fixes a problem with database files on read-only media: Internal Error using read only database file.

You can see a complete list of all SQL Compact 3.5 related KB articles here.

SqlCeCmd alpha release now available

The initial alpha release of the SqlCeCmd command line query utility is now available on CodePlex. SqlCeCmd is intended as the SQL Compact equivalent to sqlcmd, that is used with SQL Server. SqlCeCmd can be used to manage and query SQL Compact databases without the installation of Visual Studio or SQL Server Management Studio. It can be run from the command line or be called from batch files and scripts.

The utility use the SQL Compact ADO.NET provider, and only requires .NET 2.0 and SQL Compact 3.5 runtime to be installed.

The following features are available in this initial test release:

- Create new database.
- Maintain the database with the SqlCeEngine: Compact, Shrink, Repair and Recover.
- Change database options: Password, locale id, encryption mode and case sensitivity
- Run a query (DDL or DML)
- Run script files generated by ExportSqlCe
- Run any script file with multiple commands separated by “GO”

Options relating to output formatting have not yet been implemented. Please try it out and submit any comments, features requests and proposals on the CodePlex project site.

SQL Server 2008 Management Studio Express

For managing SQL Compact 3.5 (SP1) database files is now available as a stand-alone download - “only” 170 MB!

ExportSqlCe version 1.7 released

This latest release contains the following changes and improvements:

Added Update and Delete Rules on Foreign Keys
Improved error handling
Fixed output file naming bug
Binary and varbinary columns were missing size in CREATE TABLE statement

- and it now has a nice icon :-)

Go and get it here.

SqlCeCmd – SQL Compact Command Line Tool

I have started a new project on CodePlex, http://www.codeplex.com/SqlCeCmd. This project is intended to be the SQL Compact equivalent to the SQL Server SQLCMD utility. It will allow you to administer SQL Compact databases on the desktop without having SQL Server Management Studio or Visual Studio installed. You can review the intended features here. Please provide any comments you may have at the CodePlex site. A quick syntax overview:

sqlcecmd 
[ { -d SQL Compact connection string} ]
[ -e shrink | compact | create | repairdelete | repairrecover ]
[ -z new password ]
[ -q "cmdline query" ]
[ -e echo input ]
[ -i input_file ] 
[ -o output_file ]
[ -R use client regional settings ]
[ -h headers ][ -s col_separator ] [ -w column_width ] 
[ -W remove trailing spaces ]
[ -k [ 1 | 2 ] remove[replace] control characters ] 
[ -y display_width ] [-Y display_width ]
[ -b on error batch abort ] 
[ -c cmd_end ]
[ -? show syntax summary ]

SQL Compact 3.5 Schema Provider for CodeSmith now available

I have modified, improved and updated the existing SQL Compact 2005 CodeSmith Schema Provider. It is available here: http://community.codesmithtools.com/forums/p/9303/34491.aspx#34491

New/enhanced features include:

GetDatabaseName:
Now returns the sdf file name without extension

GetTableColumns:
Support for all 3.5 data types, including rowversion
Excludes system columns
Several extended properties added

GetTableIndexes:
Bug fix for same index name on different tables

GetTableKeys:
Added - gets all foreign keys

GetTablePrimaryKey:
Bug fix for returning not only primary keys.

GetTables:
Excludes system tables

Tested with Nettiers 2.3.b2 (with a slightly modified Nettiers.cst).

The Schema Provider in action:

 

Technorati Tags: CodeSmith,SQLCE,SQL Compact