2016 April Preview doesn't see SQL Prompt

PDinCA

Already running the latest 7.2 build, I downloaded and, as Administrator, installed SSMS April Preview, which is still the latest build according to the SSMS Check for Updates.

SQL Prompt is not there.

I ran a Repair from Programs and Features.

Still not there.

Many reboots have since occurred. Still.......

View ==> Toolbars ==> no sign of Red Gate anything.

SSMS 2014 is running just fine, with SQL Prompt and ApexSQL items in the main menu (textual).

Fix, please?

Running Windows 8.1 Pro, 64-bit, patched to the gunnels automatically.

Microsoft SQL Server Management Studio 13.0.14000.36
Microsoft Analysis Services Client Tools 13.0.1400.353
Microsoft Data Access Components (MDAC) 6.3.9600.17415
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.11.9600.18321
Microsoft .NET Framework 4.0.30319.42000
Operating System 6.3.9600

Aaron L

Hi Stephen,

All the version numbers look good to me, SQL Prompt should be loading into that SSMS version. Could you check if you have the following directory:

C:Program Files (x86)Microsoft SQL Server130ToolsBinnManagementStudioExtensionsSQLPrompt

It should contain a extension.vsixmanifest and RedGate.SQLPrompt.SsmsPackage.pkgdef file, which are used to tell SSMS2016 to load SQL Prompt.

One thing to try is installing this build to see if performing an upgrade (rather than a repair) fixes it.

Thanks,
Aaron.

PDinCA

That solved the problem immediately. Many thanks.

sc00by

I have the same problem but am already on the latest version of SQL Prompt so it won't allow upgrade and as previously mentioned, Repair option doesn't install it into SSMS 2016 Preview.
I don't want to uninstall / reinstall SQL Prompt as I'll lose my tab history and server tab colour coding ...

Any advice is appreciated.

Thanks,

Rob.

Aaron L

Hi Rob,

Uninstalling/reinstalling won't remove any settings or your tab history so it's safe to do.

If you want to make a backup of your settings and tab history just in case, you can make a copy of the folder where they are all stored:

%localappdata%Red GateSQL Prompt 7

Thanks,
Aaron.

sc00by

That did the trick ... and I didn't lose anything either

Thanks.