Resources for Your Developer Toolbox
Theresa W. Carey

Happy Holidays! Take the day off. Then when you get back to work, check out these new programs.

Database Reengineering

Excel       Excel Software extended the reengineering capabilities of WinTranslator to generate WinA&D data models from SQL code. Database designers can generate logical and physical data models from a SQL schema for several RDBMS products including Microsoft® SQL Server, DB2, Sybase, Informix, Oracle, and InterBase. Rich data models can represent tables, views, constraints, assertions, triggers, indexes, procedures, and other SQL elements.
      WinA&D is a tool for system analysis, requirement specifications, software design, and code generation. Modeling notations and supported methods include object-oriented analysis and design with UML, structured analysis and design using Yourdon/DeMarco, and Information Engineering (Martin)-style data models for developing information systems.
      WinTranslator is a reengineering tool for WinA&D that generates UML class models for C++, the Java language, and Delphi and structure charts from C, Pascal, Basic, and Fortran. WinTranslator processes an input SQL script file containing statements like CREATE TABLE, CREATE TRIGGER, and so on, and produces a dictionary entry list that can be imported into WinA&D.
      The new WinA&D 3.2 software automatically generates data models from the dictionary information. Data models can be edited within WinA&D and used to generate new SQL schemas for a selected RDBMS. Data models can be integrated with other WinA&D models, such as process models that show information flow or state models that show different modes of operation and event transitions. HTML reports can easily be generated to communicate models, specifications, and requirements to anyone with a Web browser.
      WinTranslator has a selection option for SQL-99, Oracle, SQL Server, DB2, Sybase, Informix, or InterBase dialects of SQL. Vendor-specific SQL statements in other dialects can also be supported with a configuration option that captures design data from the SQL script. Some RDBMS products support multiple schemas within a database. Each schema is automatically mapped to a different namespace within the WinA&D design environment.

Excel Software
19 Misty Mesa Court
Placitas, NM 87043
505-771-3719
https://www.excelsoftware.com

Multiple Network Configurations

PhatWare       PhatWare Corporation recently announced the availability of PhatWare NetProfile 2000, a product for mobile professionals who require Internet and LAN connectivity from a variety of different network configurations. Designed for Microsoft Windows® 2000, PhatWare NetProfile 2000 allows mobile users to create multiple network profiles for each network adapter.
      With NetProfile, it is no longer necessary to manually change your network settings and reboot every time you connect your portable computer to a different network. A NetProfile network profile can contain Network Identification (computer name and workgroup or domain name), TCP/IP (DHCP or static IP address/subnet mask, gateways, WINS, DNS), and proxy server information (used by Microsoft Internet Explorer). When applying new NetProfile profiles, a reboot is not required unless the profile contains a different computer name, workgroup, or domain name. Applying new network profiles is as simple as selecting the profile name from a popup menu.
      The program's features include a Windows 2000-style UI, support for all TCP/IP settingsâ€"including IP Address, WINS, DNS, and Gatewaysâ€"support for proxy server settings, support for network identification settings, support for multiple network adapters, and a small program size and memory footprint.

Phatware Corporation
3640 Country Club Drive
Redwood City, CA 94061
800-656-5426
https://www.phatware.com

Migrating Computer Personalities

Tranxition       Tranxition Corporation is shipping Personality Tranxport Professional (PT Pro) 2.0, which transfers computer personality from one Windows-based platform or PC to another, resulting in reduced migration risk. Version 2.0 features rules-based data migration and optimization, detailed migration control, and deep application support.
      PT Pro 2.0 provides IT professionals with the ability to create and manage comprehensive rules for data migration. This includes gathering data files from anywhere on the system's disk and redirecting the files to a specific folder on the destination machine with the subdirectories left intact. PT Pro automatically locates, stores, and transfers user documents, e-mail, and personalized settings including: desktop configurations, network and Internet settings and accounts, service and protocol information, Internet favorites and bookmarks, e-mail address books and inboxes, custom dictionaries, and more.
      PT Pro is ideal for preserving PC personality while enabling businesses to exercise rational control of migration processes. PT Pro 2.0 includes support for all versions of Microsoft Exchange, ACT! 2000, Norton AntiVirus 2000, WinZip 8.0, and Netscape Navigator and Communicator 4.x. PT Pro 2.0 also includes support for Adobe Acrobat Reader 4.05, Adobe Acrobat 4.0, and the latest versions of Internet Explorer. PT Pro continues to support both legacy and current versions of Outlook®, Visio®, Office 95, Office 97, and Office 2000 (including Service Pack 1).

Tranxition Corporation
3700 SW Murray Boulevard,
Suite 200
Beaverton, OR 97005
503-291-6400
https://www.tranxition.com

SocketTools Upgrade

Catalyst       Catalyst Development Corporation has released SocketTools 3.5, which includes enhanced controls and libraries for virtually every component in the package.
      Highlights include a new HTTP control and library, which supports all versions of the protocol, proxy servers, client authentication, and chunked transfers, as well as enhancements to the FTP control and library, including built-in support for four proxy server types. The FTP controls include a user-defined proxy type, multiple file transfers using wildcards, directory parsing for Unix, MS-DOS® and VMS list formats, and automatic client resynchronization.
      A new File Encoding/Decoding control is in the package, which supports uuencode and base64 encoding formats, as well as file compression. The mail controls and librariesâ€"including the SMTP, POP3, and MIME componentsâ€"have been upgraded. These components are designed to work with each other to make sending and receiving e-mails simpler.
      The SMTP control and library now supports several types of user authentication, delivery status notification, and other advanced features of the extended ESMTP protocol. You'll also find a new SocketWrench library which greatly simplifies the basic Windows Sockets API. This library is particularly useful for developers using Visual Basic® who want the low overhead and performance of a standard DLL, without the complexity of the native Windows Sockets library.
      Catalyst provides unlimited technical support through their Web site and by e-mail. A full-featured evaluation copy of any SocketTools Edition is available for download.

Catalyst Development Corporation
56925 Yucca Trail PMB 254
Yucca Valley, CA 92284
800-776-3818, 760-228-9653
https://www.catalyst.com

Project Costing and Staffing

Softstar       Softstar Systems has released Costar 6.0, a software development estimating application for Windows based upon the latest version of the COCOMO II estimating model. Costar helps produce accurate and reliable estimates of project costs, duration, and staffing.
      In addition to supporting traditional project development models, Costar supports incremental COCOMO, allowing you to model development as a series of concurrent software projects, each yielding an intermediate product. Costar lets you describe each project in as much detail as necessary, supporting an unlimited number of levels in each project and an unlimited number of components at each level. The program's effort and schedule equations may be modified to conform to each user's historical data. You can add your own cost drivers or modify the program's parameters, including the number of hours per person-month, the distribution of effort among the phases of project development, and the effort-multipliers for any cost driver. Project managers can create alternative project assumptions, and compare the results side-by-side.
      You can ask "what if" questions such as, "What if we postpone a particular feature until the next release?" or "What if we had more experienced software developers?" Costar even lets you constrain your project to either a fixed schedule or a fixed budget.
      Costar users get unlimited phone support for one year and upgrades for six months. The program package includes two books by Dr. Barry Boehm, the driving force behind COCOMO. You can download a demo of Costar 6.0 from the company Web site. Costar 6.0 runs under Windows 95, Windows 98, Windows NT® 4.0, and Windows 2000.

Softstar Systems
P.O. Box 1360
Amherst, NH 03031
603-672-0987
https://www.softstarsystems.com

Quick Takes

12Ghosts       12Ghosts Inc. has released version 21 of their 12Ghosts Windows utilities. This update includes 21 programs designed to save you clicks. Programs are included to secure documents while you are working on them and automate repetitive tasks. One utility, 12-ShutDown, comes with "auto-logoff on idle" as well as "auto-logon as predefined user." Other programs automate unattended backups, document management, reminders for important tasks, and security for your desktop.
      Version 21 comes with two new add-ons, 12-Synchronize and 12-TrayClock, which adjust your PC's time with an atomic clock on the Internet and extend the normal functionality of the Windows clock to display a date/time combination according to your preferences, and allows changing of font size and colors. You can download an evaluation version of the 21 timesaving tools at https://www.12ghosts.com.
Maillist Verify       ElcomSoft Co. Ltd. has released a new version of Advanced Maillist Verify (AMV), a Windows-based program that verifies the validity of e-mail addresses in databases, address books, and mailing lists. In addition to being a standalone program, it can be integrated into existing systems using an open COM and ActiveX®-based interface. The package includes documentation and examples for integrating Advanced Maillist Verify into Internet/intranet servers based on Active Server Pages (ASP) technology from Microsoft and ColdFusion from Allaire. Also, AMV is supplied with ISAPI and CGI modules to work with Web servers that do not support server-side scripts. The program supports all popular file formats, including Windows (.WAB) and TheBat (.ABD) address books. ODBC SQL support is there, allowing you to work with DBMS like Microsoft SQL Server, Oracle, MySQL, Microsoft Access, and even Microsoft Excel. Check it out at https://www.mailutilities.com.
G-Lock Software      G-Lock Software has released Advanced Administrative Tools 4.1 for Windows, a multithreaded network diagnostic tool for system administrators, service personnel, or anyone who simply wants to know more about their PC and its connections to the network or Internet. Its purpose is to accumulate data pertaining to network status and availability, using all of the latest development tools in network research. It is a nine-in-one utility, which includes: Port Scanner, which has an internal database of ports that analyzes hosts and the different services that have been started on them; CGI Analyzer, which will help you discover and fix all known security vulnerabilities on your Internet, intranet, and extranet systems; and Proxy Analyzer, for testing lists of proxies or verifying lists of addresses on a present proxy server.
      Other utilities in the package include: Email Verifier, a solution for the message delivery error; Links Analyzer, which scans all your URLs and Internet Explorer Favorites and notifies you when any link is being changed or has become invalid; and Network Status, a simple, easy-to-use TCP/UDP protocol monitor that displays the Internet address of both parties (the local IP and the remote IP), as well as the TCP or UDP ports in use. ProcessInfo, Whois, and System Info round out the collection. Trial versions are available at https://www.glocksoft.com/aatools.htm.

Theresa W. Carey is a freelance writer who lives in California. Her byline has appeared in Barron's and PC World. You can send her New Stuff at newstuff@microsoft.com.

From the January 2001 issue of MSDN Magazine