Can Multiple versions of SSMS and SQL Prompt coexist?

I need to support 2 very different versions of SQL Server (2005 and 2019) and I am finding I can't do this with two versions of SSMS/SQL Prompt because SQL Prompt 10 doesn't work with 2005.

Is there a way to install the newer version of SQL Prompt while preserving the older version like this? Seems like the installer just wants to go out and install the latest on all versions so there's no way to get two versions on the same computer?

SSMS 17.9.1
SQL Prompt 9.5.23
SQL Server 2005

SSMS 18.5
SQL Prompt 10.1.7
SQL Server 2019
Tagged:

Answers

  • TomWTomW Cambridge Posts: 108 Gold 1
    Hi @joe12pack

    Sadly, you can only have one version of SQL Prompt installed on an individual machine. However, while SQL Prompt 10 does not "support" SQL Server 2005, it should still work fairly painlessly with it, so you should be OK to manage both SQL instances with the same SQL Prompt version.

    Thanks,
    Tom
    Software Engineer for SQL Prompt
    Redgate Software
Sign In or Register to comment.