We've just released version 2.0 of DTS Package Compare. You can download it from:
https://www.red-gate.com/dynamic/downlo ... eDeveloper
Note that posts in this forum prior to 21st December 2005 refer to previous betas
and may not be applicable to the current beta
Dan J Archer
DTS Package Compare Project Leader
Red Gate Software
Overview of New Features
DTS Package Compare allows you to compare DTS Packages from SQL Server instances; DTS Structured Storage Files (.dts files) and snapshots. If there are differences, you can see exactly what those differences are. Snapshots can be taken of a server at a given point in time, and then later used as the basis of a comparison.
You can leave DTS Package Compare to work in the background, comparing the latest versions of packages on two servers. Meantime you can still use the application to compare particular packages of your choosing.
Since the background compare need not provide full details of each comparison, but just whether two packages are the same or different, it can use a more optimal algorithm to speed comparisons of large packages.
Compare arbitrary packages
. You can compare any package on one server against any package on another server. This can be useful for tracking package evolution where one package forms the design basis for later, similar packages.
Compare package versions
. SQL Server saves a new version of a package each time it is edited. By default, these versions are retained. In DTS Package Compare 2.0 you can see and compare any version of the package available on any server. This effectively gives you an audit trail tracking the evolution of a single package.
Password protected packages
. The application has full support for password protected packages.
Packages with custom tasks.
Properties on in house or third party custom tasks can be displayed and compared.
You can print out a summary report of all packages, or the results of an individual comparison.
You can export XML comparison results, for either the current comparison or for all packages. You can also just export details of the package contents, without comparison information.
Since some DTS packages can take some time to load, both in SQL Server Enterprise Manager and DTS Package Compare, we provide client-side caching so that future comparisons with the same package can be noticably faster.
Windows NT 4, Windows 2000, Windows XP or Windows Server 2003
Microsoft .NET Framework 1.1
Microsoft Data Access Components (MDAC) 2.8
SQL Server 2000 (or SQL Server 2000 Client) installation, Service Pack 4
10 MB hard disk space
Runs on a user’s PC (can also run on a server)
SQL Server 7 and earlier are not supported. SQL Server 2005 and SSIS are not supported.
• Memory consumption for large package sets is higher than planned for the final release.
• Exceptionally large packages over very slow connections may not load due to a loading timeout of 180 seconds. This is planned to be configurable in the final release.
• Packages with some kind of custom task, including some written in Visual Basic, may not be comparable by DTS Package Compare.
• Under some circumstances, some packages are not saved correctly in snapshots. This includes some password protected packages.
• When a snapshot is taken, success is reported even if some packages had to be skipped due to problems loading them or unsupplied passwords. A more detailed report will be given in the final release.
• The Edit Package Password… menu option defaults to editing of the password(s) for the left hand side package version being compared, rather than for both the left and right package versions. The more overt clickable “supply a password” links perform correctly.
• Clicking a “group by” header in the package list displays a “work in progress” indicator, although no work is being carried out.