DBPowerSuite
Microsoft SQL Server
  • Automate Nightly Processing
  • Generate SQL
  • Expand your application to support multiple databases
  • Transfer data from one database to another
  • Check the data integrity defined by constraints
  • Copy schema from one server to another
  • Publish and document a schema
MySQL
One of the biggest challenges facing a company is the need to execute fail-safe unsupervised database scripts nightly. A company needs to build into their automated processes conditionally-executable SQL and then to be able to programatically check whether or not the SQL executed successfully. No company wants their DBAs or System Admins to babysit such processes. No company wants their DBAs or System Admins to visually check error logs. No company wants their shell programmers to write complicated kludgy scripts to parse logs for error messages.

DBPowerSuite fufill the challenge. DBPowerSuite makes automation easy. You can run all DBPowerSuite programs from any scripting langauge. You can call DBPowerSuite programs from Perl, csh, sh, ksh . . . PHP . . . any language. All DBPowerSuite programs run unsupervised--they never require interactive user input. And best-of-all, all DBPowerSuite programs exit with a code your nightly scripts can easily check and take action upon.

DBPowerSuite has thousands of features. Click Documents above and then click on the Program Reference.

Talus Software is offering a free license which lasts till the end of July 2006. Try DBPowerSuite and see what it can do for you.

DBPowerSuite is available on Red Hat Linux systems, Solaris and Mac OS X.
Oracle
Postgres SQL
Sybase
1 Copy data from Oracle to Sybase, Microsoft SQL Server to Sybase, Postgres to Oracle, Sybase to MySQL, etc. (psOCopyTableData)
2 Automatically generate a web-site describing your database schema--with comments! (psListTablesForWeb)
3 Have batch or interactive sessions with any ODBC data source. (psOSQL)
4 Have batch or interactive sessions with any Sybase server directly through Open Client. (psSQL)
5 Control your database session's output. Create delimited text files readable by bcp or SQL*Loader. (psSQL, psOSQL)
6 Call SQL scripts from SQL scripts. (psSQL, psOSQL)
7 Replace words in SQL scripts as they execute (psSQL, psOSQL).
8 Send e-mail from SQL. (psSQL, psOSQL)
9 Embed your SQL sessions in UNIX or Perl scripts and check for their exit code. (All DBPowerSuite programs).
10 Check whether Oracle tables' abide by their check contraints. (psGCheckRules)
11 Check whether Microsoft SQL Server table's abide by their referential integrity constraints. (psGCheckRIConstraints)
12 Drop all check constraints from an Oracle schema. (psGDropCheckConstraints)
13 Add all check constraints to a Sybase schema. (psGAddCheckConstraints)
14 Copy a schema (table definitions, views, procedures, etc. and data) from one Sybase user to another. The user can be on different ASE servers. (psCopySchema)
15 Dump all databases on a Sybase server. (psDumpServer).
16 Update statistics on all tables in all databases on a Sybase server. (psUpdateServer)
17 Generate analyze table scripts for MySQL. (psGUpdateStatistics).
18 Report which disks every Sybase table and index resides on. Report disk use metrics. (psListSegments)
19 Report available devices in which to create or expand a Sybase database (psListDevices)
20 List the definitions of tables and indexes (psListTables, psOSQL)
Go to Talus Music Listen to Extreme Download MP3 by Stephanie Gervase.

© 2010 Talus Software. All Rights Reserved.

Home | Buy Software | Privacy