Comments
5 comments
-
It appears that this does not work with the Express version of Microsoft Management Studio. Is there a reason why? -
Are we supposed to post issues/bugs here or send you all an email or both or what?
-
Matthew.Wilkerson wrote:It appears that this does not work with the Express version of Microsoft Management Studio. Is there a reason why?
The Express version of Microsoft Management Studio does not support add ins in any form (neither officially nor unofficially). This is a resriction by Microsoft, and we could not find a way around it that would satisfy the requirements for SQL Refactor.
Andras -
Antitorgo wrote:Are we supposed to post them here or send you all an email or both or what?
You may do both. If you post it it might be worth starting a new topic. If you would like to send it in email please send it to Andras.Belokosztolszki at red-gate.com
Andras -
Seems to be a bright idea.
Isn't it better to improve this product so that it supports query Analyser as well.
Add comment
Please sign in to leave a comment.
SQL Refactor is an Add-In to Microsoft Management Studio. Therefore you must have Management Studio installed. SQL Refactor’s features are available from the Management Studio menus, which can access both SQL Server 2000 and SQL Server 2005.
This release introduces some of the main features of this SQL Refactor:
- SQL Lay Out reformats your T-SQL scripts. You can select this feature from the top level SQL Refactor menu. - Smart Rename renames functions, views, stored procedures and tables, and updates all the references to these renamed objects. You can select this feature from the context menu in Management Studio’s Object Explorer. - Table Split splits a table into two tables, and automatically rewrites the referencing stored procedures, views, and so on. You can select this feature from the context menu in Management Studio’s Object Explorer. - Qualify Object Names modifies the script so that all object names are qualified. You can select this feature from the top level SQL Refactor menu.
We are planning to include more features in SQL Refactor. These features will be available in the beta release. However, you are encouraged to suggest new refactorings on this forum.
To install SQL Refactor CTP download and execute the installer from:
ftp://ftp.red-gate.com/sqlrefactorbeta/sqlrefactorsetup.exe
To uninstall SQL Refactor CTP:
- In Management Studio, select Tools -> Customize… . The Options dialog box is displayed. - Drag and drop the “SQL Refactor†menu from the main Management Studio menu bar onto the Options dialog box. - Exit Management Studio. - Execute the uninstaller.
Limitations
This is a community technology preview, and it is not feature complete. There may also be discrepancies between the documentation and the functionality. You are encouraged to read the documentation before using SQL Refactor. Some of the known limitations include:
- No progress indication for long operations. - Table Split:
- Partition schemes and filegroups not yet supported. - Identity columns not yet supported.
- Smart Rename- Renaming parameters or columns is not yet available. - Rewriting referencing objects in case of more complex schema bindings does not yet work.
- SQL Lay Out and Fully Qualify Names- Laying out selections is not yet available. - Not all statements are supported. (Please let us know if you find a statement that we do not yet support.)
- At the moment uninstalling the product requires some manual steps (see above).Please do not install this version on a production machine.
Andras