Version History for SQL Examiner

2007-12-14 version 2.1:

• Feature: It is possible to hide unnecessary buttons of the main toolbar now.
• Feature: When creating a backup of a SQL Server 2008 database, it is possible to use compression now.
• Feature: It is possible to launch the Console Mode Settings Wizard when one of the sources is an empty source.
• Feature: Added the %file1, %file2 parameters for external applications.
• Change: It is possible to evoke the pop-up context menu from the keyboard now.
• Change: Added support to the ROWGUIDCOL property.
• Bug fix: When retrieving data from a SQL Server 2000 backup, the order of sorting of the fields, included in an index, was incorrectly displayed.
• Bug fix: Fixed the issue that prevented the PERSISTED property from being saved in a snapshot.
• Bug fix: Fixed the issue of the Ignore Triggers option (triggers were not completely ignored when generating a script).
• Bug fix: Fixed the issue that occurred in the process of generating a script for an extended property with a NULL value.

2007-11-07 version 2.0:

• Feature: Support for SQL Server 2008 and its key innovations (note: as MS SQL Server 2008 has not been released yet, we tested the work of SQL Examiner 2008 using the latest available beta version Microsoft SQL Server code name "Katmai" (CTP) - 10.0.1049.14);
• Feature: Support for column renaming;
• Feature: The Ignore index and constraint names option, that allows you to compare indexes and constraints by contents as well as by names, has been added;
• Feature: Command line parameter /ProcessPriority, that allows to set the priority of the application, has been added;
• Feature: Command line parameter /ReportOn, that allows to specify what categories of objects you want to include in the report, has been added;
• Feature: Command line parameter /SaveSnapshot, that allows to create database snapshots, has been added;
• Feature: Opportunity to select Empty Database as the data source has been added. This allows to generate a database script that may be run on a clean database;
• Change: The Ignore index details option doesn’t include the Ignore Unique sub-option anymore;
• Feature: Opportunity to use recent comparisons;
• Feature: The Console Mode Settings Wizard has been added to help configure settings of SQL Examiner Command Line Comparison and Synchronization tool;
• Feature: More flexible work with external programs (SQL Management Studio and SQL Query Analyzer); besides, you can now switch to other external applications;
• Feature: Program and project settings have been split up;
• Feature: We’ve added the Search bar so now you can choose to display only some objects of the object tree;
• Feature: When creating a project, you can use the objects filter (even when wildcards are used), and deselect objects that you don’t need to be compared;
• Feature: User interface design in the MS Office 2007/Visual Studio 2005 style;
• Change: Some minor GUI changes.
• Bug fix: An issue of definition of data that could not be used in the process of creating foreign keys (null-values) has been fixed.
• Bug fix: The problem of copying identity-columns when recreating tables in the Partial Synchronization mode has been fixed.

2007-02-01 version 1.6

• Feature: SQL Examiner provides full support for all MS Windows Vista significant features and innovations, and meets all the demands and recommendations of the Microsoft Corporation for applications for Windows Vista.
• Bug fix: The bug of CLR-assemblies that occurred when the assembly name was different from the file name was fixed.
• Bug fix: The indexes are automatically re-created when the user alters indexed views.
• Bug fix: The “@i” variable was sometimes uppercase and sometimes lowercase in the generated script that could lead to synchronization errors (with some specific server settings).
• Change: The tool now takes the enabled/disabled state of triggers into account.
• Change: It is now convenient to view any long database names in the New/Open Project window.
• Change: The program now ignores the usage of delimiters for SQL identifiers when comparing triggers, procedures, etc.

2006-12-11 version 1.5.5

• Feature: The full MS Windows Vista support has been added.
• Feature: The tool now saves the Full/Partial synchronization mode and also the show the synchronization script for the entire object/for the selected differences only mode you chose even when you close the application.
• Feature: The Warning if the currently checked objects will be excluded by the filter warning has been added.
• Change: It is now possible to check only objects with differences in the object tree.
• Bug fix: Some bugs connected with the partial synchronization of indexes and triggers have been fixed.
• Bug fix: The bug occurred when retrieving schema from a SQL Server 2005 backup file with the PAGE_VERIFY = NONE option set.
• Bug fix: Some minor GUI bugs have been fixed.

2006-11-15 version 1.5

• Feature: It is possible to compare the source code of CLR-objects.
• Feature: It is possible to use wildcards in the expression when selecting tables to compare and synchronize in the Console Mode utility.
• Feature: The Change project settings dialog has been added. Now it is possible to change necessary comparison options without launching the New/Open Project window once again.
• Change: When transferring procedures, functions and views to some other database, the owner or the schema is specified in the text of the object.
• Change: When changing comparison options the chosen settings could not be applied to snapshots.
• Change: The program saves the New Project window size after you have closed it.
• Bug fix: The bug occurred when retrieving permissions if a backup was used as a synchronization source.
• Bug fix: The bug occurred when scripting extended properties of non-text type.
• Bug fix: The bug occurred when retrieving CLR-procedures with the option Ignore owners enabled.

2006-09-04 version 1.4

• Feature: CLR-objects’ support has been added: now it is possible to compare and synchronize stored procedures, user-defined functions, triggers, user-defined types and user-defined aggregates.
• Feature: A trigger can be designated for the same operation (INSERT, UPDATE, or DELETE) as the First or Last trigger. SQL Examiner takes the order of triggers into account in the process of synchronization.
• Feature: It is possible to compare and synchronize the extended properties of the following objects: schema, synonyms, roles, xml schema collections and user defined types.
• Feature: It is possible to save Difference Report in the XML format.
• Feature: It takes into account whether the CHECK constraints and foreign keys are disabled or trusted. The Ignore WITH NOCHECK option has been added.
• Feature: the PERSISTED property is taken into account for computed columns.
• Feature: The Ignore extended properties option has been added.
• Feature: The Save password option has been added;
• Feature: The Ignore full text search objects and properties option has been added.
• Change: Some changes in the User Interface have been made: it is possible to add pop-up buttons to drag the windows splitter aside.
• Change: The global defaults binding are displayed on the Generate tabs. Now it is possible to synchronize it.
• Change: The unjustified recreation of a table, when it contains an identity column does not occur.
• Change: Now in the process of comparison the program takes the usage of identifier delimiters (e.g.: square brackets) in the names of functions, procedures, etc. into account.
• Bug fix: the bug occurring when retrieving schema from a backup of size more than 4 GB and if the pages are heavily fragmented.
• Bug fix: the bug occurred when procedures, functions, etc. were compared with the Ignore spaces or Ignore comments options enabled.
• Bug fix: the bug occurred when snapshots were generated; now it takes the incorrect order of the symbols into account and forces the generation of a snapshot.
• Bug fix: the bug occurred in the process of comparison of the tables that had statistics.
• Bug fix: the bug occurred when a computed column references a user-defined function and the function refers to a table;
• Bug fix: the foreign key columns with multiple dependencies between tables were incorrectly added or deleted;
• Bug fix: the bug in the color settings: it was impossible to set more than one custom color.
• Bug fix: when generating script the references to user-defined function in computed columns have been ignored.
• Bug fix: the bug occurred when opening read-only files of the project;
• Bug fix: the bugs of the Validate data function: when several foreign keys were selected for one column.

2006-03-29 version 1.3

• feature: The command line interface has been added.
• feature: The support of multi-file backup copies has been added.
• feature: The support of synonyms has been added.
• change: Now it is possible to explicitly specify the connection timeout and the query timeout.
• bugfix: Sometimes triggers were not recovered when a table was recreated.
• bugfix: Exceptions are possible in case the table a trigger is set for is mentioned in the text of the trigger.
• bugfix: While recreating tables, the program created default restrictions with modified names.
• bugfix: Sometimes an error occurred during the work with external keys when linked tables were added and modified at the same time.
• bugfix: In some cases, the advanced properties of views were not scripted.
• bugfix: The same text objects could be shown as different in the "Ignore object owner" mode.
• bugfix: Parsing bugs with constructions like FROM table1 as t1, table2 t2, table3 have been fixed.
• bugfix: The bug occurring when an identity with the initial value of 0 was used.
• bugfix: The bug with extracting full-text catalogs.
• bugfix: The logic of extracting large text objects from SQL Server 2005 backup copies has been fixed.
• bugfix: The bug related to extracting advanced properties in case-sensitive databases.

2005-12-12 version 1.2

• feature: Supporting SQL Server 2005 backup copies.
• feature: The support of partial synchronization is added.
• feature: Comparing and synchronizing the full-text search directories.
• feature: Comparing and synchronizing database extended properties.
• feature: Now it is possible to synchronize user permissions to perform operations.
• feature: Now it is possible to synchronize memberships in security accounts in roles.
• feature: Supporting backup files larger than 4GB.
• feature: Now it is possible to create a Database Variance report.
• feature: Now it is possible to select a View Style – Windows XP, Office XP, Office 2003.
• feature: The "Ignore Triggers" option is added.
• bugfix: Incorrect synchronization of composite indexes.
• bugfix: The bug while trying to open an incorrect project file.
• bugfix: Incorrectly processing numbered stored procedures in SQL Server 2005.
• bugfix: The bug occurring when the text objects are extracted: Cannot sort a row of size, which is greater than the allowable maximum of 8094.
• bugfix: The bug occurring while extracting self-reference foreign keys.
• bugfix: The bug occurring while specifying a backup folder that does not exist and trying to view the directory tree after that.

2005-09-12 version 1.1

• feature: Comparing and synchronizing SQL Server 2005 databases.
• feature: Supporting SQL Server 2005 schemas.
• feature: Working with new SQL Server 2005 data types (xml, max-types).
• feature: Supporting SQL Server 2005 xml indexes.
• feature: Supporting the additional properties of relational indexes - include, allowPageLocks, allowRowLocks.
• feature: Comparing and synchronizing SQL Server 2005 database triggers.
• feature: Comparing and synchronizing permissions.
• feature: The auto-hide feature is implemented for the object tree.
• change: The update check mechanism is modified.
• change: Minor GUI changes.
• bugfix: The bug sometimes resulting in a failure during the comparison with a database snapshot is fixed.
• bugfix: The bug occurring while information about indexes is being extracted.
• bugfix: The bug occurring when a project is opened.
• bugfix: The bug sometimes resulting in incorrect termination when information about check constraints is being extracted.
• bugfix: The bug occurring when the object filter is being used.

2005-07-25 version 1.0

• feature: Added a feature of comparing databases with a backup copy of a database and with SQL Server 2000 detached databases.
• feature: User membership in database fixed roles is taken into account.
• bugfix: Solved the situation when the registry has no information about the default backup folder.
• bugfix: The critical error occurring when triggers are modified is fixed.
• bugfix: The bug that results in generating an incorrect script when a cluster index is deleted and created on other columns is fixed.
• bugfix: The bug that sometimes results in generating an incorrect script when BLOB columns (text, ntext, image) are modified is fixed.

2005-06-15 version 0.9

• feature: Now the program detects if columns are renamed and processes this situation correctly
• feature: While generating the synchronization script, the program takes data existing in the target tables into account (if the Validate Data option is enabled)
• feature: Now it is possible to check if the existing data is unique when an attempt to add the UNIQUE, PRIMARY KEY restrictions, etc. is made (if the Validate Data option is enabled)
• feature: When the FOREIGN KEY restriction is added, the program checks if it is compatible with actual data (if the Validate Data option is enabled)
• feature: Now the program displays warnings in case logins and application fields with empty passwords are moved
• feature: While converting types, the program checks data and displays a warning in case data can be lost (if the Validate Data option is enabled).
• feature: Now the program displays a warning when a text object incorrectly changes either its name or its owner and it is possible to move such text objects correctly
• feature: Checks for updates on the site are added
• change: The new mechanism provides better control over synchronization by skipping unfinished, but non-critical steps.
• change: A connection to SQL server 6.5 is processed correctly
• bugfix: In previous versions, tables differing only in default were considered different, but they could not be synchronized. Fixed.
• bugfix: The error that appeared during the analysis of some records in the sysdepends table (on the Retrieve object dependencies step) was fixed.
• bugfix: Incorrect refreshment of the object tree after comparison in some cases.

2005-03-21 version 0.8.10

• feature: Now there is an additional step in the synchronization process — it can be used to view and solve possible synchronization conflicts
• feature: Now it is possible to solve the conflict when a NOT NULL column without the DEFAULT constraint is added to a table
• feature: The object tree now supports multiple selection that is used to select a group of objects for further synchronization
• feature: The compatibility of types when the type of column data is converted is determined
• change: No text objects referring to the table being modified are recreated if these text objects coincide in both databases
• change: With the "Keep column order" option enabled in the synchronization script, ALTER TABLE (instead of recreating the table) is used for adding new columns to the end of the table
• bugfix: The IDENTITY property is correctly added to columns — now the values stored in this column are not modified in the process of executing the synchronization script
• bugfix: Now the code for creating indexes and triggers is displayed on the first tab

2005-03-04 version 0.8.9

• feature: Now it is possible to hide service code while the synchronization script is viewed
• feature: Now it is possible to disable the automatic synchronization of dependent objects
• feature: Now it is possible to add empty lines separating synchronization steps to the script in order to make it more readable
• change: The backup settings dialog box is modified. The dialog box for selecting the folder for backups is added
• bugfix: QUOTED_IDENTIFIER was not taken into account while searching for dependent objects in text objects (stored procedures, functions)

2005-02-28 version 0.8.8

• feature: Now it possible to compare objects without taking their owners into account

2005-02-21 version 0.8.7

• change: Objects are not recreated many times during the synchronization process

2005-02-14 version 0.8.6

• feature: Snapshots (*.sesnap) are associated with the program
• bugfix: The bug with opening files having invalid structure is fixed
• bugfix: Applying settings incorrectly when the file with settings is absent
• bugfix: Saving the name of the last server incorrectly

2005-02-02 version 0.8.5

• feature: Examples are added (createDb1.sql, createDb2.sql, Snapshot1.sesnap, Snapshot2.sesnap)

2005-01-31 version 0.8.4

• feature: The Same Server option is added when a new project is created
• bugfix: Displaying interface elements incorrectly when Large Fonts are used

2005-01-24 version 0.8.3

• feature: Displaying the long name of a snapshot correctly in the status bar
• bugfix: Checking if files exist before opening them is added
• bugfix: New color and font settings were applied to the object tree only after the tree was refreshed

2005-01-18 version 0.8.2

• feature: Recreating tables without inserting existing data is forbidden, which ensures data safety
• bugfix: The bug with filling out the login and password fields when the Same Server option is enabled is fixed

2005-01-14 version 0.8.1

• feature: Help is added to all dialog boxes
• change: Timeout is increased up to 60 sec
• bugfix: Duplicating the text when text objects are extracted