Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SQL Refactor Expand / Collapse
Author
Message
Posted Tuesday, March 6, 2007 9:12 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, February 5, 2013 4:24 AM
Points: 685, Visits: 104

I got the free bundle from Redgate through this site. I have managed to install the prompt but I am at a loss as to how to access the SQL refactor component.

Help!




Everything you can imagine is real.

Post #349420
Posted Tuesday, March 6, 2007 9:41 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: Administrators
Last Login: Thursday, October 13, 2011 8:42 AM
Points: 105, Visits: 406

SQL Prompt and SQL Refactor are separate products, so SQL Prompt doesn't have a SQL Refactor component.  You can download a free trial of SQL Refactor from the Red Gate website (www.red-gate.com).



Matt Chandler
Software test engineer,
Red Gate Software
Post #349440
Posted Tuesday, March 6, 2007 9:53 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, February 5, 2013 4:24 AM
Points: 685, Visits: 104

Thanks Matt,

I know that they are separate products. Below is the content of the readme file that comes with the sql prompt bundle that i got.

--

SQL Prompt Bundle
=================

(c) Red Gate Software Ltd 2004-2007

Introduction
------------

SQL Prompt Bundle contains the following products:
- - - - - - - - - - - - - - - - - - - - - -

SQL Prompt 3.0, for providing Intelligent auto-completion for SQL Server.

SQL Refactor, for formatting SQL scripts, renaming objects, splitting tables and more.

SQL Doc, for documenting one or multiple SQL Server 2000/2005 databases


------

or maybe its just my spirit wanting free stuff.




Everything you can imagine is real.

Post #349448
Posted Tuesday, March 6, 2007 9:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 26, 2009 1:51 AM
Points: 7, Visits: 156

Hello,

When you extract the files from the bundle you will have 3 separate files: one for SQL Refactor, one for SQL Prompt and one for SQL Doc.

Did you receive a serial number for SQL Prompt or for the SQL Prompt Bundle?

Rachel

Post #349452
Posted Tuesday, March 6, 2007 10:04 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, February 5, 2013 4:24 AM
Points: 685, Visits: 104
i can't remember well but i think it was for the prompt. But the menu option for SQL refractor is disabled in Mgmt Studio.


Everything you can imagine is real.

Post #349453
Posted Tuesday, March 6, 2007 10:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 26, 2009 1:51 AM
Points: 7, Visits: 156

If you only received a serial number for SQL Prompt then unfortunately it will only enable the SQL Prompt tool and not SQL Refactor as well.

SQL Refactor is available for a 14-day trial period but if you installed all 3 elements of the SQL Prompt Bundle when you received the free serial number for SQL Prompt then it is likely that the trial has expired.  

Rachel.

Post #349467
Posted Wednesday, March 7, 2007 7:44 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, September 15, 2008 12:02 PM
Points: 1,318, Visits: 57

You will find the program as a menu item in SSMS, along with SQL Prompt if you use it. There is an issue so if the menu item is greyed out read below...

The issue you are experiencing with SQL Refactor and SQL 2005 SP2 where the Refactor menu is greyed out is a known problem with SQL 2005 SP2. There is a beta fix for this problem available - this can be downloaded from the following location:

ftp://ftp.red-gate.com/SQLRefactorBeta/sqlrefactorsetup.exe

There will be an official release of Refactor which will include this fix shortly, however hopefully this beta will solve the problem you are experiencing in the short term. Please keep an eye out for this official release.




Post #349726
Posted Wednesday, March 7, 2007 8:11 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, February 5, 2013 4:24 AM
Points: 685, Visits: 104
Thanks, that managed to enable the menu option but unfortunately it seems my trial has expired.


Everything you can imagine is real.

Post #349737
Posted Tuesday, March 13, 2007 5:30 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:55 AM
Points: 5,233, Visits: 9,463

Yes - my free download also included SQL Refactor and SQL Doc but only had a licence key for SQL Prompt.  When I contacted Red Gate they apologised for any confusion and explained that the only free product on offer was SQL Prompt.

John

Post #351057
Posted Tuesday, March 13, 2007 8:30 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, February 5, 2013 4:24 AM
Points: 685, Visits: 104
You would think that they should have mentioned that in the download. :-(
...marketing tricks.

But irregardless, I would recommend this package to any SQL developer.



Everything you can imagine is real.

Post #351148
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse