Developer Tools
Create INSERT Scripts
LockwoodTech Software announced Auto-Inserts, software that creates from any SQL Server 2000 or 7.0 database INSERT scripts that you can archive, email, check into source control, and run against another database. The software handles identity fields and can autosequence the scripting order of tables to avoid referential integrity violations even when you reload an entire database. You can tell the software what data you want scripted, and it will evaluate your data and create a T-SQL script. You can then run the T-SQL script to recreate the same data in another database. Auto-Inserts can script an unlimited number of tables and rows from a database. You can add custom comments to files as you process each table, add PRINT statements to an SQL script, delete all records from each table before processing inserts, and select the number of rows to script for each table.
Auto-Inserts costs $89 for a single-user license and $265 for a site license. Contact LockwoodTech Software at sales@lockwoodtech.com or http://www.lockwoodtech.com.
Analyze Stored SQL Server Data
FMS announced Total SQL Statistics, software designed for Visual Basic (VB) and Visual Studio .NET developers who use SQL Server. The software features statistical functions that let you analyze data. You can access the data in tables, views, stored procedures, and user-defined functions (UDFs). The Total SQL Statistics Scenario Designer lets you create analysis scenarios, which contain information about the data to analyze and statistical options to perform. Total SQL Statistics includes three functions: RunScenario(), Probability(), and Probinverse(). The RunScenario() function saves your selections to run them interactively or to let you invoke them programmatically. The Probability() function lets you calculate probability as used in the Probability Calculator. The Probinverse() function calculates inverse probability as used in the Probability Calculator.
Total SQL Statistics runs on Windows 2000, Windows NT, Windows Me, and Windows 9x systems and supports SQL Server 2000 and 7.0. Pricing is $895 for a single-user license. You can download a free personal edition for your home. Contact FMS at 703-356-4700, 866-367-7801, or http://www.fmsinc.com.
Develop Applications That Require Persistent Objects
Pragmatier announced Pragmatier Data Tier Builder, an integrated modeling tool and code and database generator for SQL Server and Visual Basic (VB). The software can simplify the development of applications that require persistent objects. The modeling tool features a GUI with an intelligent treeview, which presents the class hierarchy, a list view, and a details view. The code generator uses an advanced build engine that can optimize code. Pragmatier Data Tier Builder generates all the code necessary for a functional data tier. You can run the generated code on COM+-compatible platforms.
Pragmatier Data Tier Builder supports SQL Server 2000 and 7.0 and costs $895. The software is available in a professional edition and a personal edition. Contact Pragmatier at reception@pragmatier.com or http://www.pragmatier.com.
Business Intelligence
Build Interactive Web Environments
Active Interface announced IntraSight, graphical-reporting software for business intelligence (BI) that lets you build interactive Web environments. Based on lightweight ActiveX or JavaBean components, the software provides XML-based charting, graphics, and data visualization. You can access dozens of 2-D and 3-D view templates for traditional business charts and for specialized reporting, such as balanced scorecards, network diagrams, geographic information systems (GIS), and process control. IntraSight can query SQL tables and OLAP cubes directly from the browser. You can define update periods for near-realtime reporting of continuously changing data sources pertaining to business or IT processes.
IntraSight requires Microsoft Internet Explorer (IE) and integrates with SQL Server 2000 and Microsoft SharePoint Portal Server (formerly code-named Tahoe). For pricing, contact Active Interface at 412-901-1184 or http://www.intrasight.com.
End of Article
Prev. page
1
[2]
next page -->
