Skip to content

SQLite & SQL Server Compact Toolbox extension for Visual Studio, SSMS (and stand alone)

License

Notifications You must be signed in to change notification settings

ErikEJ/SqlCeToolbox

Repository files navigation

SQLite & SQL Server Compact Toolbox

Visual Studio Marketplace Rating Visual Studio Marketplace Downloads Twitter Follow

My tools and utilities for embedded database development

Visual Studio & SSMS 20.x extension, standalone app and command line tools, for managing all aspects of your SQL Server Compact/SQLite database files' data and schema, including generation of code, database diagrams and database documentation.

If you use my free tools, I would be very grateful for a rating or review here

Documentation

Getting started guide

Known issues with workarounds

Release notes for released versions and daily builds

Command line tools

Scripting API samples

Downloads/builds

Visual Studio Extension

Release

Download the latest version of the Visual Studio extension (for both 3.5, 4.0 and SQLite) from Visual Studio MarketPlace

Or just install from Tools, Extensions and Updates in Visual Studio!

Daily build

You can download the daily build from VSIX Gallery.

You can also automatically get the latest build of the Master branch directly in Visual Studio

If you need the Visual Studio 2010 extension, please contact me, and I can provide a link!

SQL Server Management Studio (SSMS) 20 and 17 Extension

You find the extension under the View menu in SSMS.

Release

Download the latest version of the SSMS 17 extension (for both 3.5, 4.0, SQLite and SQL Server) from Visual Studio MarketPlace

Daily build

You can download the daily build of the SSMS 20 extension from VSIX Gallery

Make sure to "Unblock" the downloaded file before proceeding!

Installing the SSMS 20 extension

Sine SSMS extensions are unsupported, you will have to manually install this extension version (at least until I or someone else decides to create an installer)

From an administrator command prompt:

Create a folder called SqlCeToolbox under C:\Program Files (x86)\Microsoft SQL Server Management Studio 20\Common7\IDE\Extensions\

Copy the extension.vsix that you downloaded from VSIX Gallery to the new folder C:\Program Files (x86)\Microsoft SQL Server Management Studio 20\Common7\IDE\Extensions\SqlCeToolbox.

Unzip the extension.vsix to the new folder. For example: "C:\program files\7-zip\7z.exe" e extension.vsix -y

You should now have 48 files in the SqlCeToolbox folder, and the extension is "installed".

Installing the SSMS 17 extension

Use the following command line:

"C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\vsixinstaller.exe" "full path to extension.vsix"

EF Core Power Tools for Visual Studio 2022

The EF Core Power Tools have moved to this repository

Standalone for SQL Server Compact 4.0 and 3.5 SP2

Release

You can download the latest release of the standalone tools from the Github releases here

Command line tools

Release

You can download the latest release of the command line tools from the Github releases here

How do I contribute

If you encounter a bug or have a feature request, please use the Issue Tracker

The Toolbox is open source and welcomes any contribution. There are a number of issues in the Backlog that the project needs help with!