SQL Effects Clarity for Sybase ASE description
Lightning Quick and very flexible database comparison tool. Interactive results.

SQL Effects Clarity is a powerful and advanced database comparison utility for Sybase ASE. The tool differentiates itself from other database comparison tools by focusing on ease of use, flexible comparison selections and criteria, lightning fast comparison performance, unique GUI review of differences (instead of scripting out the objects then doing a basic file compare - a common method in other tools), and also offers multiple results analysis and review and reporting and export methods.

SQL Effects Clarity is a software tool made for software professionals by active software engineers who have to do on a daily basis the kinds of chores the tool is designed for:
· Verifying change scripts.
· Identifying undesirable changes in a database environment - or verifying that there aren't any.
· Ensuring that your production environment is the same as your test and development environment.
· Diagnosing those odd situations where a problem happens in production - but can't be reproduced in your development environment.
· Understanding the database differences between two different releases.
· Code reviewing recent changes in stored procedures, SQL functions, views and triggers with an easy way to see line by line diffs.

Here are some key features of "SQL Effects Clarity for Sybase ASE":

· Ensure consistency between database environments painlessly
· Understand schema differences quickly and completely
· Zero in on the issues without wading through a huge diff of scripted DDL
· Perform comparisons of even very large databases quickly
· Compare specific database objects on-demand or entire databases at the click of a button
· Adapt the tool to your needs - choose which objects and attributes are compared
· Increase team knowledge - share results via reporting in a variety of formats
· Automate full featured database diff reporting as part of your build process
· Save time and money - pays for itself the first time you use it
· Learn the tool almost imeediately - very simple and intuitive user interface
· Compare all or selected tables, views, triggers, stored procedures, functions, users, roles, and user defined types
· Choose which objects to compare easily with an object comparison tree
· Determine how objects are compared with fine grained control over which attributes are used for comparison
· Find all differing objects immediately with a summary "Differences Only" view
· See differences in the context of the enitre schema with our unique expandable "Side by Side" tree view
· Visualize the exact differences of objects and attributes in specific detail
· Drill down to see line by line differences for text based SQL objects using integrated text diff tool
· View, save, and print syntax highlighted SQL code from text based objects
· View and print differences list reports, and full differences reports
· Choose reporting export format for your needs - HTML, RTF, Text, Excel, PDF, XML
· Repeat common comparison scenarios easily by saving connections, selections, and settings in re-loadable files
· Control the tool via command line with support for all features of the product


Limitations:

· 14 days trial
· Nag screen