ApexSQL Data Diff updated to 2010.01

Separate backup sets can now be selected for comparison from Backup data sources.

Zoom [+]

Set default options in ApexSQL Data Diff.

ApexSQL Data Diff compares database backups against each other or against live databases. ApexSQL Data Diff features: automate Database comparisons with a Command Line Interface, compare database backups without having to restore them, synchronize databases in one click, filter objects using regular expressions, visually browse different sections for Compared, Identical and Incomparable objects and more. ApexSQL Data Diff offers you several ways to view the data comparison results and supports SQL Server 2008.

ApexSQL Data Diff is also available as part of ApexSQL Developer Studio and ApexSQL Universal Studio

Updates in 2010.01

• Separate backup sets can now be selected for comparison from Backup data sources
• New Summary and warnings step has been implemented in Synchronization Wizard
• View DDL main grid context menu command is now available for Backup data sources
• New All records grid has been added to Data Differences panel
• Previous Different Row, Next Different Row, Previous Different Cell and Next Different Cell toolbuttons have been added to Data Differences panel toolbar
• New Office 2007 style interface with ribbon bar, quick access toolbar, and ApexSQL Data Diff button has been introduced
• New Resources ribbon bar has been introduced for quick access to Help page, Support forum, Training page, FAQs, Knowledge base, Troubleshooting, Contact and Get Updates dialog boxes
• New standard Project Management dialog has been introduced
• Project Management dialog now shows recently used projects or projects stored in any folder of choice
• Projects can be Pinned/Un-Pined to Recent Projects list on Project Management dialog
• Data sources can be compared directly from Project Management dialog box
• Synchronization direction is shown directly in Project Management dialog box for selected project
• Project description can be edited directly from Project Management dialog
• 'Show on Startup' option has been added to Project Management dialog box
• Startup Action options group has been added to Options dialog to control Project Management dialog behavior. Available choices are 'Show Project Management dialog', 'Show last opened project' and 'None'
• Project Defaults can now be defined for newly created projects
• Project options can now be saved as current user defaults settings
• Project options can now be reset either to current user or to ApexSQL defaults
• Each project option has now an associated tooltip with description
• New tooltip balloons have been added to data source bars of main window Status bar
• Options dialog has been redesigned with new Office 2007 button bar
• Application can now be presented in 3 color schemes: Blue, Silver and Black
• The following new connection options have been implemented for Database data source: 'Execution timeout' and 'Encrypt connection'
• Object filter Project Settings form tab has been redesigned for improved usability
• New Object Filter Editor allows to filter objects based on 'Exclude if' or 'Include if' conditions
• New Object Filter Editor can use the following comparison operators: 'Equal', 'Not Equal', 'Between', 'Not between', 'Contains', 'Not contains', 'Begins with', 'Ends with', 'Any of' and 'None of' and the following logical operators: 'And', 'And not', 'Or' and 'Or not'
• Row Filter dialog now shows filtered row counts
• Show Advanced Tabs button in Project Management dialog box displays additional steps (Object filter, Object mapping and Additional scripts)
• Editor for synchronization script can be selected on Output Options step of Synchronization Wizard
• Main grid supports 2 predefined grouping types: Group by object type and No grouping
• New main grid row filter can use the following comparison operators: 'Equal', 'Not Equal', 'Begins With', 'Ends With' and 'Contains' for string columns and 'Equal', 'Not Equal', 'Greater Than', 'Greater Than Or Equal', 'Less Than' and 'Less Than Or Equal' for numeric columns
• Number of checked objects and number of filtered objects are now displayed in main window Status bar
• New Comparison Statistics dialog is shown in response to clicking on Checked and Excluded bars of main window Status bar
• Data cache location has been made an option and is available on Options dialog
• The following new switches have been added to CLI: /bs1:arg [ /backup_set1 ] : Specifies source backup set GUID, /bs2:arg [ /backup_set2 ] : Specifies destination backup set GUID

About ApexSQL

ApexSQL LLC is a leading provider of value added software tools for Microsoft SQL Server. The company has a simple goal - be the best company for acquiring and retaining customers of SQL Server Tools in the world. It looks to accomplish this by dedicating itself completely to the customer via rapid response to service, support and sales requests and customer friendly policies. ApexSQL is so committed to support it has created a Support Engineers Creed. The company strives to deliver the maximum amount of functionality and features to the customer in the spirit of Microsoft Software Development and to be incredibly responsive to feature requests from users. ApexSQL has a singular commitment to develop and design the best SQL Tools in the world in terms of feature set, performance and quality. The company is privately held and is based in Chapel Hill, North Carolina.