How can we help you today? How can we help you today?

Uninstall SQL Refactor before installing SQL Prompt 5

We have had a number of reports of error messages when installing SQL Prompt 5 alongside SQL Refactor. Our testing has confirmed that under certain configurations the two products cannot co-exist.

Please uninstall SQL Refactor as well as SQL Prompt 4 before trying out the SQL Prompt 5 Early Access release.

If you have already encountered errors, please try uninstalling both SQL Refactor and SQL Prompt 5, and then reinstalling SQL Prompt 5.

If you need features of SQL Refactor that are not yet included in SQL Prompt 5, then please uninstall SQL Prompt 5 and reinstall SQL Refactor. Please also let us know what features they are, and we will prioritise the most popular ones for earlier SQL Prompt 5 Early Access releases.

Note that a future Early Access release will uninstall both SQL Refactor and SQL Prompt 4 for you, and that eventually all features of SQL Refactor will become Pro features of SQL Prompt 5.

Paul Stephenson
SQL Prompt Project Manager
Red Gate Software
Paul Stephenson
0

Comments

10 comments

  • weswinkler
    I find the Summarize Script feature of SQL Refactor very useful. Please work to include this in SQL Prompt V5 as soon as possible.

    Also, I would like to see the script summarization window become a bit more interactive. E.g., allow me to highlight a summary section, change to the query window to make changes, and then return to the summarization window and REFRESH the summarization.
    weswinkler
    0
  • Giggles220
    I use the Qualify Object Names command in SQL Refactor especially when I am writing a script in a database I'm not familiar with or if I'm giving my query to someone else. Are there plans to include this in SQL Prompt 5?
    Giggles220
    0
  • David Atkinson
    weswinkler wrote:
    I find the Summarize Script feature of SQL Refactor very useful. Please work to include this in SQL Prompt V5 as soon as possible.

    Also, I would like to see the script summarization window become a bit more interactive. E.g., allow me to highlight a summary section, change to the query window to make changes, and then return to the summarization window and REFRESH the summarization.

    Implementing this as a modal dialog doesn't seem to have been ideal. We can't make any promises, but we'll see what we can do to improve matters.

    David Atkinson
    Product Manager
    David Atkinson
    0
  • Paul Stephenson
    Giggles220 wrote:
    I use the Qualify Object Names command in SQL Refactor especially when I am writing a script in a database I'm not familiar with or if I'm giving my query to someone else. Are there plans to include this in SQL Prompt 5?

    Yes, we will be including Qualify Object Names in SQL Prompt 5.

    Thanks for your feedback!

    Paul Stephenson
    SQL Prompt Project Manager
    Red Gate Software
    Paul Stephenson
    0
  • broughtie
    Layout SQL would be the command I'd like to see prioritized.
    broughtie
    0
  • Paul Stephenson
    Hi broughtie,

    The Lay Out SQL command of SQL Refactor has been superseded by the Format SQL command in SQL Prompt 5. Please try it out!

    Regards,
    Paul Stephenson
    SQL Prompt Project Manager
    Red Gate Software
    Paul Stephenson
    0
  • broughtie
    Ah, missed, that. Format SQL works great, thanks. Would have been nice to be able to import my refactor settings file, but I think I've got it setup the same again.
    broughtie
    0
  • ceacl
    I too received the Refactor errors after installing Prompt 5. As suggested above I uninstalled both Refactor and Prompt 4 however they both still appear on the SSMS menu.

    Any recommendation on how to fully uninstall and remove them from SSMS?
    ceacl
    0
  • Paul Stephenson
    Hi ceacl,

    If you want to remove the old menus manually, you can go to Tools -> Customize -> Toolbars -> Menubar -> Reset .

    Then restart SSMS to make the SQL Prompt 5 menu re-appear.

    Regards,
    Paul Stephenson
    SQL Prompt Project Manager
    Red Gate Software
    Paul Stephenson
    0
  • Bernard Sheppard
    I miss my SQL Refactor keystrokes - annoying I have to learn new ones to Format SQL rather than to Layout SQL.

    Minor niggle, but would be a good option to allow "SQL Refactor shortcut keys".
    Bernard Sheppard
    0

Add comment

Please sign in to leave a comment.