Monday, February 16, 2009

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 ]

No comments: