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)

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

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

Apex SQL Debug 2008.02 is an expert and powerful Add-in to SQL Server Management Studio that offers step into, step out of, step through debugging with support for conditional break points, watches, call stacks and more.

Major Functions:

1. Add-in to SQL Server Management Studio
2. Offers step into, step out of, step through debugging with support for conditional break points, watches, call stacks and more
3. Lists the dependent objects called by the profiled procedure
4. User defined values can be set for procedure parameters prior to profiling

Major Features:

1. T-SQL Debugger
   • Initialize Debugging of a Stored Procedure:Initiate debugging of a stored procedure with user defined values for input parameters.
   • Stored Procedure Step Through Mid Execution Call Stack. List the dependent objects called by the profiled procedure.
   • Defining Conditional Breakpoints: This feature is helpful to break running code based on user defined conditions such as errors, excessive rowcount or connections.
   • Lazy Debugging: With Lazy Debugging, ApexSQL Debug executes your stored procedure and logs everything that happens during execution. A report will be generated containing a list of all executed steps, how long each step took, what variables were changed, etc. You can export the results to PDF or Excel.
   • Display Temp table contents: View the contents of a temp table during debugging.
2. T-SQL Performance Profiling
   • Initializing Profiler on a Stored Procedure: User defined values can be set for procedure parameters prior to profiling.
   • Profiling Results: Profiling reports show a sophisticated analysis of the procedures processing results including performance by line, and before and after results of parameter values.
   • Profiling - Summary: The ApexSQL Profiler provides a high level view of procedure performance allowing you to quickly view things like the slowest statements.
   • Profiling Script View: View T-SQL performance by processing time. Visually recognize slow running statements.
   • Profiling Detail View: View T-SQL performance in user-friendly table-like dialog. Different metrics can be grouped and sorted helping you identify bottlenecks within your stored procedure call stack, so that you can optimize your stored procedures accordingly.
   • Profiling Variable/Parameter History

   • WareSeeker Editor
     

Apex SQL Clean 2008.02 is a powerful tool to find out and delete unreferenced and unused Database objects like tables, views and procedures from within the database itself (cross-dependencies) and also from client applications (like a VS.NET project).

References are created using proprietary technology that doesn't rely on SQL system tables. Apex SQL Clean includes a powerful visual Dependency viewer that converts database dependies into a graphical display. Apex SQL Clean will analyze a client whether it be VB, ASP, Delphi etc to determine what SQL objects are actually being used and what objects aren't.

It will also analyze the database itself to see what internal references exist among SQL objects. Based on the Apex SQL Clean analysis it will generate a file of SQL drop statements to Clean your database of these useless objects.

Major Features:

1. Support for tables, views, procedures, rules, defaults, triggers, user defined datatypes, user defined functions and file dependencies
2. Interface shows Object dependencies and objects with dependencies to it.
3. Graphical display of number of unreferenced objects.
4. DDL script for object colorizes referenced object names to allow you to visual spot the dependencies.
5. Users have the ability to create file search pattern to analyze all files of a particular language or project (i.e .cs, .vb, .frm, .aspx, .pas, .cls)
6. The file processing engine is recursive simply point to a directory and it will search all subdirectories for files that match the search pattern you create.
7. Automatic drop statement creation. Interface shows whether file is referenced, has references and the number of each. Simply clicking on the object will display all references.
8. Double clicking on any object will script it.
9. Interface supports grouping/ungrouping by object type.
10. Column level dependencies
11. Proprietary Dependency parsing algorithms for SQL 7, 2000 and 2005 that provide accurate dependency analysis vs native SQL Server methods that use sysdepends table
12. SQL Server 2005 Support
13. New Auto-update feature
14. Regular expression object filter
15. Graphical Dependency Viewer
16. Support for tables, views, procedures, rules, defaults, triggers, user defined datatypes, user defined functions and file dependencies
17. Interface shows object dependencies and objects with dependencies to it.
18. Graphical display of number of unreferenced objects.
19. DDL script for object colorizes referenced object names to allow you to visual spot the dependencies.
20. Users have the ability to create file search pattern to analyze all files of a particular language or project (i.e .aspx, .cs, .pas, .cls)
21. The file processing engine is recursive - simply point to a directory and it will search all subdirectories for files that match the search pattern you create.
22. Automatic drop statement creation.
23. Interface shows whether file is referenced, has references and the number of each. Simply clicking on the object will display all references.
24. Double clicking on any object will script it.
25. Interface supports grouping/ungrouping by object type.
26. Unicode support
    

Enhancements:

• Updated product

Requirements:

• ADO MDAC 2.8 MSSQL Server v7,
• Win2000, 2005 or 2008,
• NET 2.0 SP1 Run time
• NET Framework 1.1

WareSeeker Editor

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

Apex SQL SSIS Compare 2008.02 is astrong software to detect quickly differences in your SQL Server Integration Services (SSIS) packages. The tool features fast comparison of multiple SSIS packages which makes it especially helpful for troubleshooting SSIS package problems.

Major Features:

Enhancements: Ability to document SSIS 2008 packages

WareSeeker Editor