|
|
|
|
|
SQL-Programmer IX SP2 with TSQL Debugger 1 2 3 4 5 6 7 8 9 10 11 12 I mentioned earlier that being able to connect to more than one server can come in handy. How many times have you created an object in one database or server and wanted to put that same object in another database or server? To do this, you might have extracted a script and then executed it against that database or server. You may have used DTS or any number of other tools. SQL-Programmer gives you a method that is very straightforward and intuitive. How about drag and drop? When you drag an object from one database or server to another one and drop it, you will see the figure below. You can retain the ownership, give it a new name, and retain permissions. SQL-Explorer will extract the appropriate script and execute it against the other database or server transparently to you.
The SQL-Documenter is the first add-on module. Being able to produce high quality, consistent documentation is extremely useful. You simply drill into the databases and objects that you want. Those objects indicated by an open book icon will be included in the reports.
The figure below shows one of the reports generated and an example of the detail that is provided. However, the SQL-Documenter is rather crippled for most uses. It has one capability, print the reports to paper. You can not publish them as HTML docs. You can not save them to any kind of file other than a report file. The saving grace is that this file is simply a plain text representation of the report. Most places that I've been publish all of the documentation to an intranet. With SQL-Programmer you can generate the report outputs, but someone will have to manually convert them to something that can be published on your intranet. It would be nice to be able to publish the reports directly to an intranet and have them neatly linked together. Even generating them in HTML docs with a separate TOC that would require someone to edit the links would be a step forward.
SQL-Programmer IX SP2 with TSQL Debugger 1 2 3 4 5 6 7 8 9 10 11 12 |
All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.
.