Standard Features (Sybase)

 Cross-Platform Database support
 Secured as password are stored in Encripted format
 Controlled as only installer can start program
 SQL Editor to execute SQL Queries
 Browse Database objects like
  * Aliases
  * Check Constraints
  * Defaults
  * Foreign Key Constraints
  * Foreign Keys
  * Groups
  * Indexes
  * Primary Key Constraints
  * Primary Keys 
  * Stored Procedures
  * Rules
  * Segments
  * Database Statistics
   ** Database Owner
   ** Create Date
   ** Total Size
   ** Data Size
   ** Log Size
   ** Free Size
   ** Database Options set
   ** Total number of Objects like
    *** Groups
    *** Indexes
    *** Segments
    *** Stored Procedures
    *** Tables
    *** Triggers
    *** Users
    *** Views
   ** Data Devices along with size and location
   ** Log Devices along with size and location
    
  * System Tables
  * User Tables
  * Triggers
  * Unique Key Constraints
  * Users
  * User Datatypes
  * User Messages
  * Views
  * Top Ten Tables showing rowcount and size
 option to browse by individual owner 
 Browse Data Devices
 Browse Dump/Tape Devices
 Browse Logins
 Server Configuration Details
 Server Statistics like
  * Server Entries
  * Network Type
  * Port
  * Total Number Of Databases
  * Total Number Of Data Devices
  * Total Number Of Dump Devices
  * Total Number Of Tape Devices
  * Total Database Size
  * Total Device Size
  * Total Unused Device Size
  * Total Mismatch Size
  * Total Number Of Logins
  * Total Number Of Tables
  * Total Number Of Procedures
  * Total Number Of Views
  * Total Number Of Triggers
  * Total Number Of Indexes
  * Total Number Of Objects
  * Total Memory
  * Total Procedure Cache
  * Lock Scheme
  * Default Character Set
  * Default Sort Order ID
  * Max Network Packet Size
  * Max Online Engines
  * Number Of Locks
  * Number Of open Databases
  * Number of Open Indexes
  * Number Of Open Objects
  * Version
 Find Column in Tables
 Process Monitor to Monitor Server Activities
 Automatically Save and Recall Executed Queries
 Conditional Replace based on IF THEN ELSE
 Compare Unix Diff Files and text files
 Helpdb - Database Space Usage with auto refresh

ConfigDiff - Compare Server Configuration Parameters useful for DR Servers

DBAdmin - Easily Create/Drop/Alter/Replicate 
 * Devices
 * Segments
 * Databases
 * Aliases
 * Logins
 * Groups
 * Users
 * Grant / Revoke
 * Threshold

  ** Object Permissions
  ** Command Permissions
  ** Cache / buffer pools
  ** Threshold 
  ** Fragmentatioin.
  ** Add Server Entries to the sql.ini file.

 
Schema Extraction
 Create      - Generates syntax which was used while creation
 Drop          - Generates syntax to drop one/all objects
 Grant       - Generates syntax to grant permissions
 Revoke     - Generates syntax to revoke permissions
 Compare  - Compares Object counts between two Servers/Databases
 Compare DDL    - Compares DDLs between two Servers/Databases

 SaveIndividual - Saves DDLs to individual files which are helpful
                                  to manage Source Code Control System.
 Object Types
  * Aliases
  * Devices
  * Databases
  * Defaults
  * Groups
  * Indexs
  * Logins
  * User Messages
  * Rules
  * Segments
  * Stored Procedures
  * Tables
  * Triggers
  * Users
  * Views
 
Automate Dump/Load
 * Database Dump / Load
 * Transaction Dump/Load
 * Suffix Database Files with predefined Format like
    DD,DDMM,DDMMYYHH,HHMin etc.
 * Saves Dump/Load History along with dump and load time.
 
Smart Universe - Build Query Universe
 * Add Executed query to the universe
 * Assign Column level parameters as filter
 * Get Query from Universe directly into SQL Editor.

SQL Builder - Generate Select Query
 * Join up to 4 tables
 * Automatically generate where conditions based on the matching field names.

Migration - Cross-platform data transfer
 * Transfer table data from Sybase To Sybase,Oracle,SQL Server and vice versa.