Uninstall SQL Refactor before installing SQL Prompt 5

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson, Paul Stephenson

Uninstall SQL Refactor before installing SQL Prompt 5

Postby Paul Stephenson » Fri Aug 27, 2010 2:37 pm

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
 
Posts: 109
Joined: Fri Jul 23, 2010 9:22 am
Location: Cambridge, UK

Please work on Summarize Script

Postby weswinkler » Fri Aug 27, 2010 10:58 pm

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
 
Posts: 32
Joined: Tue Nov 11, 2008 8:12 pm

Postby Giggles220 » Tue Sep 07, 2010 1:59 pm

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
 
Posts: 114
Joined: Thu Dec 07, 2006 9:06 pm
Location: Albany, NY

Re: Please work on Summarize Script

Postby David Atkinson » Tue Sep 07, 2010 3:28 pm

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
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Re:

Postby Paul Stephenson » Tue Sep 07, 2010 3:53 pm

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
 
Posts: 109
Joined: Fri Jul 23, 2010 9:22 am
Location: Cambridge, UK

Postby broughtie » Wed Sep 08, 2010 9:52 pm

Layout SQL would be the command I'd like to see prioritized.
broughtie
 
Posts: 24
Joined: Wed Jun 07, 2006 8:10 pm

Postby Paul Stephenson » Thu Sep 09, 2010 1:06 pm

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
 
Posts: 109
Joined: Fri Jul 23, 2010 9:22 am
Location: Cambridge, UK

Postby broughtie » Thu Sep 09, 2010 4:55 pm

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
 
Posts: 24
Joined: Wed Jun 07, 2006 8:10 pm

Uninstalling Refactor and Prompt 4

Postby ceacl » Wed Oct 06, 2010 6:39 pm

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
 
Posts: 12
Joined: Wed Jun 03, 2009 11:38 pm

Postby Paul Stephenson » Thu Oct 07, 2010 9:07 am

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
 
Posts: 109
Joined: Fri Jul 23, 2010 9:22 am
Location: Cambridge, UK

Keeping shortcut keys for Format/Layout would have been nice

Postby Bernard Sheppard » Sun Oct 31, 2010 11:36 pm

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
 
Posts: 39
Joined: Wed Oct 12, 2005 2:24 am
Location: Melbourne, Victoria, Australia


Return to SQL Prompt 5 EAP

Who is online

Users browsing this forum: No registered users and 0 guests