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

System Requirements: MDAC 2.8(ADO 2.8) MSSQL Server v7, 2000 or 2005, .NET 2.0 Run time

Enhancements: Major Feature, Major Fix Release

You will be able to visually observe the differences in the objects script shown side by side. Apex SQL Diff also allows you to programmatically synchronize the databases based on the differential analysis.

Best of all Apex SQL Diff is fast - if will process the largest database in seconds, not hours, using server side comparisons that leverage the full processing power of SQL Server.

Apex SQL Diff 2008.03 is a powerful Database comparison and synchronization tool. Automatically generate scripts to synchronize two databases, graphically view object script differences, run unattended via the command line or programmable API.

Quickly and accurately compare database structures. Compare live databases, snapshots, and even Source Control Projects/Labels. Automate Database comparisons with a powerful. Command Line Interface (included as a standard option). SQL Server 2008 support

Major Features:

1. Use Source Control labels and projects as data source
2. Compare SQL Scripts to other data sources
3. Manage Projects and view project information in one compact dialog
4. Filter by Difference Codes
5. Generate richly detailed reports
6. Synchronize databases in one click
7. Choose SQL Scripts to run before and/or after synchronization
8. View script differences with your favorite file diff tool
9. Schedule and Run jobs unattended, overnight etc.

Enhancements : updated product

Requirements:

1. MDAC 2.8(ADO 2.8)
2. MSSQL Server v7, 2000, 2005, or 2008, .NET 2.0 SP1 Run time

WareSeeker Editor

1. Support for SQL Server 2008 New Features
2. Use Source Control labels and projects as data source
3. Compare SQL Scripts to other data sources
4. Manage Projects and view project information in one compact dialog
5. Filter by Difference Codes
6. Generate richly detailed reports
7. Synchronize databases in one click
8. Choose SQL Scripts to run before and/or after synchronization
9. View script differences with your favorite file diff tool
10. Schedule and Run jobs unattended, overnight etc.

Enhancements:

• New Data Types: all new datatypes are fully supported and objects using the ones can be compared and synchronized without limitations. This includes Date, Time, Hierarchy, and Spatial datatypes.
• Enhancements in indexes: all new properties of the indexes are fully comparable and can be synchronized without limitations as parts of their parent objects
• Enhancements in column properties: the application can track differences in all new column attributes, for example, SPARSE NULL against NULL; all of them are fully supported and can be synchronized in either direction along with parent objects
• Enhancements in procedure parameters and user-defined types: all the enhancements are fully supported and processed by the product
• Data compression in tables, indexed views, indexes and constraints: differences in data compression can be tracked for any respective object and synchronized without limitations
• Change Tracking and Change Data Capture: both features are fully supported; the application determines whether CHANGE_TRACKING is enabled or disabled for a table and can synchronize the detected changes making parent tables equal, also any calls to Change Data Capture procedures from within your objects are also be tracked, differences can be reported and synchronized and dependencies to a captured object can be taken into account on synchronizing with the dependencies

Apex SQL Diff 2008.07 is a comprehensive software which automatically generate scripts to synchronize two databases, graphically view object script differences, run unattended via the command line or programmable API.

Major Features:

1. Quickly and accurately compare database structures
2. Compare live databases, snapshots, and even Source Control Projects/Labels
3. Automate Database comparisons with a powerful Command Line Interface (included as a standard option)
4. SQL Server 2008 support

Enhancements:

• Minor Feature,
• Minor Fix Release

Requirements:

• MDAC 2.8(ADO 2.8),
• MSSQL Server v7, 2000, 2005, or 2008, .
• NET 2.0 SP1 Run time

ApexSQL Diff 2008 offers users a speedy and functional Database comparison and synchronization tool. Automatically generate scripts to synchronize two databases, graphically view object script differences, run unattended via the command line or programmable API.
Quickly and accurately compare database structures. Compare live databases, snapshots, and even Source Control Projects/Labels. Automate Database comparisons with a powerful Command Line Interface (included as a standard option). SQL Server 2008 support

Major Features:

1. Support for SQL Server 2008 New Features
2. New Data Types: all new datatypes are fully supported and objects using the ones can be compared and synchronized without limitations
3. Date and Time – simplifying your work with date and time data, providing increased date range, fractional seconds precision, and time zone support. The application can track and synchronize differences in the datatypes scale where it’s applicable, for example, time(5) against time(7)
4. Hierarchy – allowing you to construct relationships among data elements within a table
5. Spatial – predefined CLR data types in SQL Server allowing you to represent information about the physical location and shape of geometric objects
6. Enhancements in indexes: all new properties of the indexes are fully comparable and can be synchronized without limitations as parts of their parent objects
7. Enhancements in column properties: the application can track differences in all new column attributes, for example, SPARSE NULL against NULL; all of them are fully supported and can be synchronized in either direction along with parent objects
8. Enhancements in procedure parameters and user-defined types: all the enhancements are fully supported and processed by the product
9. Data compression in tables, indexed views, indexes and constraints: differences in data compression can be tracked for any respective object and synchronized without limitations
10. Change Tracking and Change Data capture: both features are fully supported; the application determines whether CHANGE_TRACKING is enabled or disabled for a table and can synchronize the detected changes making parent tables equal, also any calls to Change Data Capture procedures from within your objects are also be tracked, differences can be reported and synchronized and dependencies to a captured object can be taken into account on synchronizing with the dependencies
11. With the optional ApexSQL Source Control Add-in, developers can leverage the full power of popular source control systems like Subversion, Microsoft Team Foundation Server, and SourceGear Vault. ApexSQL Diff allows you to compare live databases against Source Control labels and projects.
12. Directly compare SQL files (object-creation scripts) to other data sources (live databases, snapshots, etc.).
13. The Difference Code Filter allows you more granular filtering of your comparison result set.
14. ApexSQL Diff offers you several ways to view the comparison results in a well designed HTML Report. You can also use Printable version of the report.
15. The Synchronization wizard is designed for “one-click” synchronization using default options.

Enhancements: updated product

System Requirements:

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

WareSeeker Editor

Apex SQL Data Diff 2008.02 is a program for comparing the contents of two databases and database Backups.

Major Features:

1. Support for SQL Server 2008 New Features
   • New Data Types: all new datatypes are fully supported; data in tables and indexed views exposing these types can be compared and synchronized without limitations
   • • Date and Time – simplifying your work with date and time data, providing increased date range, fractional seconds precision, and time zone support:
     • • Date – defines a date within the accuracy of one day
       • Time – defines a time of a day based on a 24-hour clock within the accuracy of 100 nanoseconds
       • Datetimeoffset – defines a date that is combined with a time of a day that has time zone awareness and is based on a 24-hour clock within the accuracy of 100 nanoseconds
       • Datetime2 – defines a date that is combined with a time of day that is based on 24-hour clock within the accuracy of 100 nanoseconds: can be considered as an extension of the existing datetime type
     • Hierarchy – allowing you to construct relationships among data elements within a table
     • • Hierarchyid – represents position in a hierarchy and sets the desired relationship between rows
     • Spatial – predefined CLR data types in SQL Server allowing you to represent information about the physical location and shape of geometric objects
     • • Geography – represents data in a round-earth coordinate system and stores ellipsoidal (round-earth) data, such as GPS latitude and longitude coordinates
       • Geometry – represents data in a Euclidean (flat) coordinate system
   • Enhancements in column properties: the data from columns having these attributes is compared seamlessly to any other column
   • • Sparse columns - ordinary columns that have an optimized storage for null values
     • XML COLUMN_SET - a column of this type is only materialized when selected, and will return you all the non-NULL sparse columns in a row as an XML BLOB. COLUMN_SET column is treated as a calculated column and as any of them can be compared but cannot be sycnhronized
     • FILESTREAM varbinary (max) – the new way of storing BLOB data allowing you to store the data in the file system. Unlike columns defined with FILESTREAM attribute the ordinary varbinary(max) columns store their data in the tables. Such columns are treated as ordinary BLOB’s and the data from them get compared and synchronized the same way
     • Note: The only limitation is that FILESTREAM filegroups aren’t documented and thus tables with FILESTREAM columns aren’t grouped in the TOC
   • Data compression in tables, indexed views, indexes and constraints: differences in data of the compressed objects are detected seamlessly to uncompressed ones and also fully supported for synchronization
   • • Data (Row and Page) Compression – allows you to compress whole tables; can be configured for a whole table and/or indexed view for each partition in case of tables. ROW compression means storing fixed length data in variable length storage format and PAGE compression means minimizing the data redundancy
2. Compare and synchronize data faster than previous versions
   • ApexSQL Data Diff 2008 compares and synchronizes data up to 3x faster than previous versions.
3. Compare database backups without even having to restore them
   • No need to restore database backups to compare them. ApexSQL Data Diff treats database backups like they’re live databases.
4. Fully customize the user interface using colours and background patterns of your choice
   • ApexSQL Data Diff 2008 allows you to choose how you want comparison results to be displayed. Select the colour and background that best help you pinpoint different or equal data.
   • Source and Destination columns as well as different rows are visually differentiated using colours of your choice
5. Compare objects with different names, different schemas, and even different columns
6. Learn the application quicker through a more refined, usable user interface
   • Get help straight from the interface. Use ApexSQL Data Diff’s balloon tips and refined user interface to get to know the application as quickly as possible.
7. Visually browse different sections for Compared, Identical , and Incomparable objects
   • Immediately find Identical and Incomparable objects in one click via tabs in the result set
8. Manage Projects and view project information in one compact dialog
9. Filter objects using regular expressions
10. Generate richly detailed reports
    • ApexSQL Data Diff offers you several ways to view the data comparison results as HTML. You can also use Printable version of the report.
11. Synchronize databases in one click
    • The Synchronization wizard is designed for “one-click” synchronization using default options.
    • Or customize the synchronization by going through the other steps. You can even show or hide advanced steps using the wizard’s advanced button.
12. Schedule and Run jobs unattended, overnight etc
    • ApexSQL Data Diff offers a powerful console application allowing the tool to be used in automated processes, to be run nightly, scheduled, unattended etc. All relevant GUI operations can be performed via command line interface. The Command Line Interface offers scores of option switches, support for XML argument files as well as standard switches like Test and Help.

Requirements:

1. Software Pre-requisites: Microsoft SQL Server versions 7.0, 2000, 2005, or 2008
2. Required Components not included with Installation:
   
   • Microsoft ActiveX Data Access Objects Library (ADO) (MDAC) 2.8 or greater
   • Microsoft .NET Framework 2.0 SP1
   • Microsoft Windows Script 5.5 or greater
3. Compatible Operating Systems:
   • Windows 2000
   • Windows XP
   • Windows 2003
   • Windows Vista
   • Windows 2008
   • Compatible with 64-bit OS versions.
4. Processor: Pentium Class Processor 600 Mhz or higher
5. RAM:512 MB RAM (256 MB minimum)
6. Disk Space for Install: 40 MB Free Disk Space (100 MB Preferred)

Apex SQL Log API 2008.01 is such a useful tool which is able to help users with auditing modules and will bring much convenience.

ApexSQL Log API is a programmable API that adds transaction log auditing capabilities to your own applications. It enables you to tap into ApexSQL Logs auditing capabilities and functionalities eliminating the need to code them yourself.

ApexSQL Log API is primarily intended for development of specialized auditing modules for your applications. Because it exposes SQL Server's transaction log to your application, it can also be used for data recovery (although ApexSQL Log offers more advantages and features in this regard) and performance tracking (e.g. track most updated tables and pages).

Major Features:

1. Develop auditing modules for your applications
2. Create and customize audit reports of your SQL Server's transaction log
3. Easily use your SQL Server's transaction log to recover data
4. Analyze row history for historical changes
5. Track most updated tables and pages
6. "No Excuses" SQL 2005 and 64-bit support

ApexSQL Log API is a programmable API that adds transaction log auditing capabilities to your own applications. It enables you to tap into ApexSQL Logs auditing capabilities and functionalities eliminating the need to code them yourself.

ApexSQL Log API is primarily intended for development of specialized auditing modules for your applications. Because it exposes SQL Servers transaction log to your application, it can also be used for data recovery (although ApexSQL Log offers more advantages and features in this regard) and performance tracking (e.g. track most updated tables and pages).


Features
- Develop auditing modules for your applications
- Create and customize audit reports of your SQL Servers transaction log
- Easily use your SQL Servers transaction log to recover data
- Analyze row history for historical changes
- Track most updated tables and pages
- "No Excuses" SQL 2005 and-64 bit support

System Requirements: MDAC 2.8(ADO 2.8) MSSQL Server v7, 2000 or 2005, .NET 2.0 Run time

New features in this version:: initial release

Apex SQL Tools has released new version of Apex SQL Report. Apex SQL Report is a web solution crafted for SQL developers. Apex SQL Report is a SQL tool that generates HTML and graphical reports. New Apex SQL Report includes fusion charts, multi column sorting, grouping & filtering using Janus web grid, export PDF, Excel & XML, Office 2003 style, drill down reports, automated web installation

System Requirements: ADO MDAC 2.8 MSSQL Server v7, 2000 or 2005, .NET 1.1 Run time, IIS 5 or higher

New features in this version:: updated product

Apex SQL Tools has released new version of Apex SQL Report. Apex SQL Report is a web solution crafted for SQL developers. Apex SQL Report is a SQL tool that generates HTML and graphical reports. New Apex SQL Report includes fusion charts, multi column sorting, grouping & filtering using Janus web grid, export PDF, Excel & XML, Office 2003 style, drill down reports, automated web installation

System Requirements: ADO MDAC 2.8 MSSQL Server v7, 2000 or 2005, .NET 1.1 Run time, IIS 5 or higher

New features in this version:: updated product