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 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.