|
|
|
|
|
RapidSQL 5.2 1 2 3 4 5 6 7 8 9 10 Data source discovery is a welcome addition. As a consultant, I move around to many environments. The most time consuming task in getting started is in registering all of the servers I need to work with. If you have half a dozen, it isn't that big of a deal. I've been in environments where I had 40 development servers and over 700 production servers. Working in environments like that, I got very good at registering one server, exporting the registry key, opening the file in Notepad, and doing a copy/paste/change to add in the rest. That process could still consume several hours. The auto-discovery will interrogate the network and give me a list of all of the SQL Servers. I can then simply select some or all of the server and register them in one action. You will still have to put in a user name and password the first time you connect.
Managing all of the data sources can become a chore as well, especially with frequent password changes. The Manage Data sources feature gives access to all of the data sources that you have registered so that you can manage all of the connection properties from one window.
The Script Execution Facility is a new feature in DBArtisan 5.03. This is a first generation feature that does a pretty good job. However, there are several improvements that need to be made to make it very useful. The Script Execution Facility allows you to execute a script against multiple servers in batch. If you had a particular script that needed to be run against 40 or 50 servers, you would spend several hours connecting to each server and running the script. The Script Execution Facility reduces this to minutes. The first tab is where you add the script that you want to run. You will notice one thing missing here. There is no open button! This means you have to either type the entire script from scratch into this window or save a script to a file, open it in Notepad, copy it to the clipboard, and paste it into the script window. Very kludgy and cumbersome. A simple open button would have been most welcome. The other thing that causes an irritation with this feature is that it is a modal dialog. While the Script Execution Facility is open, you can not access anything else in DBArtisan, so make sure you already have the script you want to execute copied to the clipboard before bringing up this dialog.
|
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.
