DBDiff for Oracle Ver. 3.03 Release Notes


The following are the changes that DBDiff for Oracle has gone through since Ver. 1.0:

Ver. 1.0: 
Original Release.

Ver. 1.1:
Problem with long data being truncated - fixed.
Problem with comparing data in tables with long fields - fixed.
Ability to save report in RTF format.
Ability to compare View's source.
Update Help File

Ver. 2.0:
Problem comparing data on fields with # on the name - fixed.
Added ability to add where statements for table and view data comparison to compare data subsets.
Problem with date fields truncated on display on occassions. - fixed.
Ability to create an upgrade script.
Ability to execute user defined sql statement and compare results.
Ability to rerun previously executed comparisons.
Ability to save/load configurations.
Ability to run from the command line.
Display problem in report - fixed.
Window size and location is now restored from run to run.
Native connection to Oracle.
Significant performance improvements.
Ability to specify date format.
Update Help File.
Order of columns is now like on database, and not alphabetic.
Ability to choose which owner (user) is to be compared, no longer forcing logon to owner user.
Option to change the font style and size in the report.
Ability to print the report.
Ability to compare Types and Type Body.

Ver. 2.01:
Added access to General Options from SQL Compare
Update Help File
Fixed length for user defined types in upgrade script

Ver. 2.02:
Upgrade script was including existing constraints - fixed

Ver. 2.03:
Problem with printing multiple page reports - fixed

Ver. 2.04:
Constraint delete rule and search condition are now trimmed for a more accurate compare.
Problem with constraint difference report formatting - fixed
Problem comparing data in Oracle 7.x server - fixed

Ver. 2.05:
Fixed Core dump when logged on, then log on again but hit cancel, then hit start without selecting database
Trim constraint search condition for more accurate compare
Fixed problem with comparing index column positions

Ver. 2.06
Fixed problem when scripting indexes in some versions of Oracle 7.x

Ver. 2.07
Fixed intermittent problem comparing constraints in different versions of Oracle

Ver. 2.08
Fixed formatting problem with privileges.

Ver. 2.09
Fixed problem with ALTER MODIFY clause when "nullable" attribute was same in both databases

Ver. 3.0
Added capability to generate data upgrade scripts
Changed Config file to be ASCII file to allow manual updates
Added option to close Start dialog for Quick Config save without need to run compare
Added option to Save and Save as Config file
New option to Rerun SQL without opening SQL Compare window
Fixed problem comparing data for tables and views that included " (quotes) on column names
Added Browse buttons to SQL Compare for quick access to saved SQL Statements
New option to execute SQL files from SQL Compare, use @path to load file (ex. @c:\tmp\myfile.sql)
Fixed problem with all uppercase sql statements for SQL Compare
Object lists made wider for ease of use
Fixed issue with reserved words used as column names in create table statements
Special characters in SQL Compare are now removed before starting
Fixed problem with treating IP Addresses as numeric
Advanced pages now remember which was selected for ease of use
Fixed issue with trigger names being truncated from script
Plan table is no longer compared
Passwords are now stored encrypted in registry
When clause in Triggers not being compared now fixed
Fixed Delete Cascade rule that was not scripted on alter statements
Added option to delete entries from Recent Connections list

Ver. 3.01
Fixed issue with Delete statement when Primary Key or Unique index used in Where clause.

Ver. 3.02
Fixed problem in Insert statements when primary key(s) not in first position.
Fixed problem with Long fields (XP Crash)
Fixed issue with empty lines in Triggers and View at the end of the code, no longer reported as differnces
Problem with comparing triggers when schema names are different, owner now is not included in description

Ver. 3.03
Fixed missing blank space on cretae trigger statements
Referencing clause missing on upgrade script for triggers