How do you add sql prompt to another target post install

markradcliffe

I installed the updated to 9.5 then installed smss 18, but prompt doesn't show up. Rerunning the installation it doesn't give me the option to add extra targets as it thinks that version is already installed, repair also doesn't work.

How do I add my existing version of prompt to ssms 18 without uninstall? (I don't want to uninstall incase I lose all my settings/tab history etc).

markradcliffe

@Tianjiao_Li

I just waited for an update and the update installed into the new one fine.

Tianjiao_Li

Hi @markradcliffe

This is unfortunately not possible at the moment. Please feel free to post this idea on our user voice forum.

To get SQL Prompt into SSMS 18, you have to uninstall and reinstall SQL Prompt post SSMS 18 installation. However, I'd like to assure you SQL Prompt doesn't delete settings when you uninstall/reinstall. They're stored in localappdata and the installer doesn't clear that out, so settings persist after reinstall. You can always backup the files to be safe though.