SQL Compact Command Line Tool

	SQL Compact Command Line Tool

CodePlex
Open Source Community

RSS

All Project Updates

Issue Tracker

Releases

Reviews

Source Code

Wiki & Documentation

RSS

View All Comments | Print View | Page Info | Change History (all pages)

Home

Project Description
Administer SQL Compact databases directly from the command line, without having Visual Studio or SQL Server Management Studio installed. Only requires NetFx 2.0 and SQL Compact installed. Command line options similar to sqlcmd. Also runs any SQL Compact script files. Runs scripts generated by ExportSqlCe

The specifications (in the form of documentation on usage) for the utility is available with the current release.

A three part tutorial on SqlCeCmd usage is available here:
SqlCeCmd tutorial part one – Managing database files
SqlCeCmd tutorial part two – Creating database objects and adding data
SqlCeCmd tutorial part three – query options

Fabrice Moll has made available available a SqlCeCmd inspired utility, that allows you to run scripts on Windows Mobile. A blog article and a download link is available here

For more SQL Compact news and tips, visit my blog at http://erikej.blogspot.com

I have decided to use the CodePlex project http://www.codeplex.com/commandline as the command line parser in this project.

Last edited Nov 6 2011 at 9:23 AM by ErikEJ, version 21

26 people are following this project (follow)

Downloads

Microsoft Public License (Ms-PL)

This license governs use of the accompanying software. If you use the software, you accept this license. If you do not accept the license, do not use the software.

1. Definitions

The terms "reproduce," "reproduction," "derivative works," and "distribution" have the same meaning here as under U.S. copyright law.

A "contribution" is the original software, or any additions or changes to the software.

A "contributor" is any person that distributes its contribution under this license.

"Licensed patents" are a contributor's patent claims that read directly on its contribution.

2. Grant of Rights

(A) Copyright Grant- Subject to the terms of this license, including the license conditions and limitations in section 3, each contributor grants you a non-exclusive, worldwide, royalty-free copyright license to reproduce its contribution, prepare derivative works of its contribution, and distribute its contribution or any derivative works that you create.

(B) Patent Grant- Subject to the terms of this license, including the license conditions and limitations in section 3, each contributor grants you a non-exclusive, worldwide, royalty-free license under its licensed patents to make, have made, use, sell, offer for sale, import, and/or otherwise dispose of its contribution in the software or derivative works of the contribution in the software.

3. Conditions and Limitations

(A) No Trademark License- This license does not grant you rights to use any contributors' name, logo, or trademarks.

(B) If you bring a patent claim against any contributor over patents that you claim are infringed by the software, your patent license from such contributor to the software ends automatically.

(C) If you distribute any portion of the software, you must retain all copyright, patent, trademark, and attribution notices that are present in the software.

(D) If you distribute any portion of the software in source code form, you may do so only under this license by including a complete copy of this license with your distribution. If you distribute any portion of the software in compiled or object code form, you may only do so under a license that complies with this license.

(E) The software is licensed "as-is." You bear the risk of using it. The contributors give no express warranties, guarantees or conditions. You may have additional consumer rights under your local laws which this license cannot change. To the extent permitted under your local laws, the contributors exclude the implied warranties of merchantability, fitness for a particular purpose and non-infringement.

Current	V 1.2
Date	Wed Apr 8 2009 at 8:00 AM
Status	Stable
Rating	2 ratings 5004 downloads
More	View all downloads

Recent reviews (more)

Easy and robust tool. Exactly what I need to use in MSBuild script. Thank you!

Activity

7 30 All days

Page Views	301
Visits	142
Downloads	84
Application Runs	N/A

View Detailed Stats

SQL Compact Command Line Tool

Recent reviews (more)

Activity

Related Projects