Soft82.com » Windows » Developer Tools » Database » Database Applications » UDB Workbench 3.3.3

View screenshots

UDB Workbench Description

SQL editor, database schema/data comparison tool for DB2

UDB Workbench is a development environment for DB2 UDB databases. It includes many features, such as comparing and synchronizing database schemas, packaging schemas and content of DB2 UDB database. SQL editor in UDB Workbench supports syntax highlighting, code completion, SQL formatting, script execution, and query results support editing, grouping, searching, and more.

Key Features

* Support loading schema from both file and database
* Powerful SQL editor that supports code completion, syntax highlighting, SQL formatting, multiple levels of undo and redo, drag-and-drop edit, column mode edit, code folding, etc.
* Convenient query tool that supports filtering and grouping query results; in addition, query results can be exported to Excel spreadsheet or as a set of SQL statements
* Integrated "Diff" tool for schema comparison as well as data comparison
* Generate synchronization script for database schema synchronization
* Loaded schema will be updated automatically after execution of DDL statements

Flexible Connectivity
* Support DB2 UDB 6.X/7.X/8.X/9.X
* Support loading schema from both file and database

Easy Database Object Manipulation
* Support scripting database objects
* Support long script execution. If script was executed from the beginning to the end and error has occurred, the statement where the error occurred will be highlighted
* Loaded schema will be updated automatically after execution of DDL statements

Powerful SQL Editor
* Support code completion that supports wildcard search, parameter hinting and tooltip information
* Support SQL formatting; include letter case conversion, for example, "TITLECASE" -> "TitleCase", "CAMELCASE" -> "camelCase", etc.
* Support line revision marks, split view, full screen edit, drag-and-drop edit, column mode edit, code folding, widlcard search, multiple levels of undo and redo, Unicode and DOS/UNIX/MAC formatted files

Convenient Query Tool
* Allow editing, grouping, searching, filtering and sorting
* Table and record views to see data the way you like it
* Query results can be exported to Excel spreadsheet or as a set of SQL statements

Integrated "Diff" Tool for Database Comparison as well as Data Comparison
* Color-coded side-by-side comparison makes it easy to pinpoint at a glance
* Allow edit and synchronize data comparison results

Generate Synchronization Script for Database Schema Synchronization
* User will be alerted when synchronization script contains any warnings, such as, data truncation, incompatible data type conversion, etc.
* Permit user to review and manually update synchronization script prior to executing it

Other Useful Features
* Convenient to view information on dependencies between database objects
* Generate script to recover invalid database objects, recovering objects include inoperative views, inoperative triggers and incorrect NEXTVAL of identity columns
* Generate script to export data, import data, load data, REORG tables and RUNSTATS tables

UDB Workbench Limitations

14-day trial

UDB Workbench Version History

UDB Workbench Download Button For Your Site

If you want to place a Download Button for UDB Workbench on your website just insert the following code:

If you want a Link to this page you can use one of the logos bellow:

UDB Workbench User Reviews

New Database Applications Software

MyDbExplorer Team Edition May 23, 2012 Connect to virtually any relational database backend				SQL Client May 23, 2012 Connect to your database with this tool
Nevron SSRS Vision May 22, 2012 Professional Data Visualization Component Suite for SSRS				DbWrench May 18, 2012 Our goal with DbWrench is to make database design cycles quicker and easier
Sfairadora May 17, 2012 Flexible tool for small databases with functions of spreadsheet and text output				Reportizer May 17, 2012 Database reporting tool
dbForge Schema Compare for Oracle May 16, 2012 Compare and synchronize Oracle databases with ease				DTM DB Stress Professional May 16, 2012 A utility for stress testing the server parts of information systems and applications
LinqConnect May 16, 2012 A fast and easy to use ORM solution				SQL Vehicle Database Download + ASP.Net May 16, 2012 Get the 1904-2013 vehicle data in MSSQL and MySQL formats
Association Manager May 15, 2012 ALL-IN-ONE, Easy to Use and Membership and Event Management Solution for Associations				DataCleaner May 14, 2012 An Open Source application for analyzing, profiling, transforming and cleansing data
SQL 2 Excel May 14, 2012 Import SQL queries in Excel tables				dbForge Schema Compare for MySQL May 14, 2012 Tool to compare and synchronize structures of MySQL databases
Database .NET May 14, 2012 A simple, uniform and intuitive database management tool for multiple databases				ERD Concepts May 14, 2012 Database software for professionals
dbForge Data Studio for SQL Server May 14, 2012 Chief query tool for SQL Server data analysts and developers				ETL-Tools QlikView Connector May 10, 2012 An ideal tool for customers who are working with complex and bad quality data
Log Table Viewer May 10, 2012 Provides a unified logging interface for your SQL code				DbVisualizer Personal May 10, 2012 Helps you with both the development and maintenance of your databases

Last 7 Days Most Downloaded Database Applications Products

DB Load Generator 34 downloads The easy way to test your database setup, server performance or sql query effectiveness				TOra 19 downloads Database management GUI that supports accessing most of the common database platforms
Firebird 16 downloads Firebird is a relational database offering many ANSI SQL-92 features				SQLDumper 16 downloads SQL Server Dumper enables you to dump selected SQL Server database tables into SQL INSERT
DbVisualizer Personal 13 downloads Helps you with both the development and maintenance of your databases				EMS SQL Manager for MySQL 13 downloads State-of-the-art GUI tool for MySQL Server administration and development
NGen NHibernate Code Generator 12 downloads A Mapping generator for NHibernate via FluentNHibernate and NHibernate.Burrows				SQLite3 9 downloads A command-line access program for SQLite databases
Pdxrbld 8 downloads Utility for checking and repairing Paradox tables				EMS SQL Manager for PostgreSQL 8 downloads Powerful graphical tool for PostgreSQL DB Server administration and development

All Time Most Downloaded Database Applications Products

DB Load Generator 3,344 downloads The easy way to test your database setup, server performance or sql query effectiveness				TOra 802 downloads Database management GUI that supports accessing most of the common database platforms
Firebird 3,331 downloads Firebird is a relational database offering many ANSI SQL-92 features				SQLDumper 6,388 downloads SQL Server Dumper enables you to dump selected SQL Server database tables into SQL INSERT
DbVisualizer Personal 1,069 downloads Helps you with both the development and maintenance of your databases				EMS SQL Manager for MySQL 2,065 downloads State-of-the-art GUI tool for MySQL Server administration and development
NGen NHibernate Code Generator 492 downloads A Mapping generator for NHibernate via FluentNHibernate and NHibernate.Burrows				SQLite3 256 downloads A command-line access program for SQLite databases
Pdxrbld 128 downloads Utility for checking and repairing Paradox tables				EMS SQL Manager for PostgreSQL 1,478 downloads Powerful graphical tool for PostgreSQL DB Server administration and development