Apex SQL Diff API 2005.02

1. Full API access to ApexSQL Diffs comparison and synchronization engine
2. Create programs to schedule or automate comparison and synchronization
3. Use ApexSQL Diffs comparison and synchronization capabilities in your own apps
4. Compare and synchronize both schema and data
5. Compare and synchronize live database schemas for different SQL Server versions
6. Create and compare Offline Database snapshots
7. MS SQL 2008 support; also supports MS SQL 2000 and MS SQL 2005
8. Audit data can be stored in a database separate from the audit database.
9. Custom filters for reports allow you the flexibility to customize generated reports from log storage tables.
10. Lookups and Watches allow you to Log not just the modified data but any related data within the table or the database.
11. ApexSQL Audit can now automatically detect whether changes in table definitions may have damaged triggers and automatically repair them.
12. Scriptable, customizable trigger templates that allow you to modify triggers.
13. Profiles automatically save your field and audit selections from your last session. No more tedious reconstruction of Audit plan.
14. Trigger management module - delete, enable/disable view triggers in an easy to use interface.
15. Incredibly functional template editor enables you to modify triggers or create your own using Microsoft VBScript or JScript and leveraging the full power of Microsoft Script parser and debugger.
16. Template editor offers intellisense support for the Audit object model and includes a built in property page.
17. Powerful data management module for deleting audit data. Functionality includes the ability to create, save and schedule Data Transformation Jobs. The DTS job manager also allows for editing and deleting existing jobs.
18. Amazingly comprehensive Help file includes step by step articles, full object model, examples and architects notes.
19. Real Reports - audit reports that allow you to print and export preformatted HTML.
20. Both Standard and Aggregate Reporting supported - reports can be output to Excel, text, HTML and printer.
21. An Audit data management grid allows you to filter, sort and group Audit data for quick and powerful analysis.
22. Easily manage Audit architectures by editing scripts from within the application, installing architecture, removing architecture and running an analysis on the integrity of the current database's architecture.
23. Ability to view triggers directly from interface and even enable / disable them directly from the main form.
24. The Table list indicates which tables are currently audited.
25. Quick controls allow selection of all tables, all field and all audit options or any combination of these.
26. View object DDL directly from the application.
27. Write triggers directly to the database, automatically call SQL Server Query-Analyzer and load in the script file or use default script editor.
    

Enhancements: Minor Fix Release

Requirements:

1. MDAC 2.8 (ADO 2.8)
2. MSSQL Server v7
3. 2000 or 2005
4. NET 2.0 Run time