Script SQL Server "UPSERTs" for tables

Sample //IF NOT EXISTS (SELECT [Id] FROM [dbo].[CmsAssets] WHERE [Id] = '4de62dea-832e-49dd-baa1-a3730077b75c') // INSERT INTO [dbo].[CmsAssets] ([Id], [ClientId], [Created], [CreatedBy], [Modifi...

Id #11804 | Release: None | Updated: Wed at 12:32 PM by ErikEJ | Created: Wed at 12:32 PM by ErikEJ

Max database size not set

In standalone when setting to value other than 256

Id #11803 | Release: Standalone 3.7 for SQL Server Compact 4.0 | Updated: Tue at 6:19 PM by ErikEJ | Created: Tue at 12:38 PM by ErikEJ

Check for reportviewer existence

In both add-in and standalone, and show message to download System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.ReportViewer.WinForms, Version=11.0.0.0, Culture=neutral, Pu...

Id #11797 | Release: vNext (version 4.0) | Updated: Mon at 11:37 AM by ErikEJ | Created: Sat at 6:52 AM by ErikEJ

Remaining SQLite initial features

Fix remaining features: Build Table (in progress/not working) Edit Top x Rows View Data as Report Script As xxx, including Script as INSERTs Import Data from CSV

Id #11790 | Release: vNext (version 4.0) | Updated: Jul 21 at 3:57 PM by ErikEJ | Created: Jul 21 at 3:57 PM by ErikEJ

Database passwords containing semicolon fails on VS2012

Hi, I have a SQL CE 3.5 database password protected and its password includes a semicolon character. When using SQL Server Compact Toolbox on VS 2010 I can connect to this database without an...

Id #11756 | Release: vNext (version 4.0) | Updated: Sat at 6:54 AM by ErikEJ | Created: Jun 19 at 10:41 AM by marcothz

Improved Build Table

Remove Add/Delete Add "Move Up" and "Move Down"

Id #11661 | Release: Release 3.7.3 Visual Studio add-in | Updated: Apr 10 at 12:04 PM by ErikEJ | Created: Apr 10 at 12:04 PM by ErikEJ

Support SQLite

Scripting on database level, query editing, and execution initially Get connections from Server Explorer and use System.data.SQLite (include x86 dll with add-in)

Id #11646 | Release: vNext (version 4.0) | Updated: Jul 21 at 3:58 PM by ErikEJ | Created: Mar 25 at 2:13 PM by ErikEJ

Support multiple foreign key columns

in GUI -

Id #11501 | Release: None | Updated: Apr 10 at 12:06 PM by ErikEJ | Created: Jan 5 at 12:25 PM by ErikEJ

Support multiple index columns

In GUI form. Auto generate Index name + use Grid with dropdown

Id #11500 | Release: Release 3.7.3 Visual Studio add-in | Updated: Apr 10 at 12:05 PM by ErikEJ | Created: Jan 5 at 12:25 PM by ErikEJ

Hotkeys in editor

I saw that keyboard shortcuts in editor were removed after the 2.4 version but why? I would appreciate very much if I could run the script without take off the hands of the keyboard to point the mo...

Id #11460 | Release: vNext (version 4.0) | Updated: Jul 23 at 11:29 PM by InteXX | Created: Dec 12, 2013 at 12:31 AM by N_Neto