xSQL Documenter v4.5 is available for
download now. The new version includes the following new features and updates:
- Support for SSRS in SharePoint Integrated mode.
- Support for Informix 9.
- Support for exclusion lists in SSRS (Microsoft Report Server)
- Support for fetching permissions objects in Oracle.
- Support for fetching dependencies between objects in different schemas in Oracle.
- Support for drawing data model diagrams with GraphViz.
- Improved performance when excluding a large number of objects.
- Added textboxes for delimiters in the GUI.
- Bug fix: exclude indexes if parent table is also excluded.
- Bug fix for DB2 if can't get pagesize.
- Bug fix: fixed a bug for Oracle where functions weren't being returned unless DocumentProcedure was set TRUE.
- SSIS fix: take server name from file path for DTSX files if the path is UNC.
The much anticipated
Oracle Data Compare tool for comparing and synchronizing data in two Oracle databases has been released.
Built on top of a robust, proven data comparison and synchronization platform the Oracle Data Compare is slated to become the tool of choice for Oracle Database Administrators and Oracle Developers across the World.
Oracle Data Compare features include:
- Cross version support: Oracle Data Compare supports Oracle 9i, Oracle 10g, Oracle 11g and can compare and synchronize data across those versions.
- Proven platform: Oracle Data Compare is built on top of our proprietary Universal Data Comparison™ platform that has been in production on thousands of computers for over 5 years.
- Modern GUI: intuitive, elegant, efficient, the graphical user interface reflects the latest standards in user interface design.
- Support for tables and views: In addition of comparing tables Oracle Data Compare provides for comparing views as well, both regular views and materialized views.
- Oracle Data Type support: both simple and complex data types are supported. Large-object fields (LOB) are properly scripted even when they reach or exceed Oracle inline restrictions for such fields.
- Custom mapping feature: gives you total control on how the tables and views from both databases being compared are paired together.
- Custom Comparison keys: Oracle Data Compare allows you to define your own custom comparison keys based on any combination of available fields. The comparison keys are used to pair the rows from both sides.
- View differences: a flexible comparison results grid makes it easy and efficient to see the color coded data differences.
- Safe synchronization scripts: Oracle Data Compare generates safe, transactional synchronization scripts that allow you to synchronize in either direction.
- Robust Script Execution Engine: no script is too large for Oracle Data Compare - the proprietary script execution engine ensures that large scripts including scripts for LOB fields are executed successfully and efficiently.
You can download the new version
here...
We have just released a brand new, completely re-worked version of our
xSQL Data Compare for SQL Server.
Coming 7 years after the release of the very first version of xSQL Data Compare, the new version 4 reflects a wealth of accumulated experience and a countless amount of comments and suggestions we have received from our users during those years.
Here is what's new in version 4 of SQL Server Data Compare:
- New comparison engine - robust, highly efficient comparison engine compares millions of rows faster while tightly controlling resource utilization.
- New modern GUI: the graphical user interface has been completely reworked to reflect the latest standards in user interface design.
- Workspace: an improved, simplified workspace that provides for a one click re-compare eliminating the hassle of repeatedly configuring comparison sessions.
- Improved memory management: eliminates any database size limitations due to memory constraints. Custom built algorithms handle serialization of both data rows and script fragments as needed.
- Error handling: non-critical errors are registered and reported but do not stop the data comparison operations.
- Enhanced functionality: many new options have been added like the ability to compare views, ability to compare databases with different collations, variable transaction size etc.
- Mapping Rules: allow the user to customize the way the database objects are paired together. Mapping rules include schema mapping, object name mapping and data type mapping.
- Key validation: in addition of the data type compatibility the new SQL Server Data Compare provides for validating the uniqueness of the selected comparison key.
- Improved Scripting: especially for binary fields and large text fields. The script for large fields is generated in fragments of a predefined size and sent to SQL Server one block at a time.
You can download the new version
here...
Just released
xSQL Documenter V4 with the following new features/enhancements:
- Support for Microsoft Integration Server 2005/2008, Teradata 13 and SQLite;
- Enhanced Extended Property Editor to support more platforms and support for comments on procedure parameters;
- A new "columns" section for table valued functions showd what columns they return (SQL Server only);
- Deterministic, schema bound and inline properties for functions were added (SQL Server only);
- Ability to suppress object dependencies on schemas (SQL Server only);
- Ability to specify max number of threads in GUI (the equivalent of the command line switch /threads);
- Support for replacing tabs with spaces in DDL;
- Scripting of users, logins, and roles for SQL Server;
- Support for connecting to Oracle using ODBC;
- More details in the foreign keys section for SQL Server;
- Specify sample rows from tables separately from sample rows for views since views can be very "expensive";
- Ability to order sample rows;
You can download the new version
here...
The new build of
xSQL Builder improves the handling of the backup files when the users chooses the "Create destination database from a backup" option and also comes with a new and improved install mechanism.
You can download the new build
here...
The new build of
xSQL Data Compare introduces two small changes that should not affect the majority of the users:
- A bug fix for very large Sql Server numeric values that trigger an overflow exception when converted to .NET native type (decimal in this case).
- An enhancement related to the way values of the type hierachyId are handled. The hierarchyId values will be scripted and synchronized even when they are not well constructed.
You can download the new build
here...
We have just published version 3.5 of our database comparison tools,
xSQL Object and
xSQL Data Compare now with support for SQL Server 2008 R2.
Following is the complete list of changes:
- Support for SQL Server 2008 R2
- The passwords for SQL Server connections are now encrypted and stored in the workspace file thus eliminating the need to enter the password each time the xSQL comparison tools are launched
- Fixes the discrepancies between the name in the object definition and the name in the system catalog. This enhancement addresses an issue caused when the sp_rename procedure is used to rename objects with sql definition such as procedures, views, functions and triggers. The procedure sp_rename in these cases changes only the name in the sys catalog, but it does not change the name in the object's definition. This particular problem manifests itself mostly on SQL Server 2000 databases.
- A new schema options named "Include objects with invalid dependencies" replaces the previous option named "Include views with invalid dependencies"; in addition to views this option now affects stored procedures, functions and triggers.
- Trial expiration issue on Windows Vista and Windows 7 with UAC on. The enhancement addresses an issue with early expiration of xSQL Object and xSQL Data Compare trial period on Windows Vista and Windows 7 when the UAC is turned on - it guarantees that both tools will be fully functional with no restriction for the duration of the trial period. After the trial, the ../products will revert to Lite edition.
- Some enhancements and bug fixing in the command line utilities including a newly added error code that tracks script execution errors.
- A fix to stored procedure multi-line comments.
- An enhancement in the way xSQL Data Compare handles identity columns. Explicit updates of the identity columns are no longer supported and will trigger data warnings.
You can download the new version
here...
[DISCONTINUED] A new build of xSQL Version Control (xSQLVC) for SQL Server is now available for download. The new build simplifies the configuration steps while giving you more choices on how you wish to copy the master development database from the master server to your local machine - in addition of the backup and restore option you can now copy all or part of the database via SQL Scripts. You can read more about xSQLVC here... [DISCONTINUED]
[DISCONTINUED] We are happy to announce the release of xSQL Version Control (xSQLVC) for SQL Server. xSQLVC is the SQL source control utility you have been waiting for - it allows teams of developers to work worry-free on their local copies of the database while ensuring that all changes that they make are automatically documented and propagated throughout the development team - your development team synchronized.
xSQL Database Version Control allows users to: - Get a copy of the master development database onto their machine.
- Auto generate database change scripts that can be checked in to the master.
- Get changes that other developers may have checked in.
- Maintain a complete history of database changes.
- Organize database change scripts into releases.
- Rollback changes if and when necessary.
- View who has done what changes to the database, when and why.
- Focus on development instead of consuming the energy managing database changes.
- Supports SQL Server 2008/2005/2000
You can read more about xSQLVC here...
[DISCONTINUED]
A new version of
xSQL Profiler including new features and improvements is now available for download.
This new version includes:
- ability to load the trace data directly to the central repository from a network share without having to go through the monitored servers temp db;
- ability to set different polling intervals for each server for a given trace;
- option to set server level traces reducing the number of traces that will need to be started on the monitored server when database level filtering is applied
A new version of
xSQL Profiler including new features and improvements is now available for download.
This new version includes:
- ability to load the trace data directly to the central repository from a network share without having to go through the monitored servers temp db;
- ability to set different polling intervals for each server for a given trace;
- option to set server level traces reducing the number of traces that will need to be started on the monitored server when database level filtering is applied
We are very excited to announce the release of
Script Executor 3 with support for SQL Server and MySQL.
Script Executor provides for deploying multiple Sql Scripts against multiple target servers/databases.
Script Executor allows the user to:
- Organize target databases into logical database groups.
- Organize Sql Scripts into logical script containers that can be nested similarly to the windows folder structure.
- Map script containers to databases groups indicating that all scripts in the given container should be executed against all databases on that group.
- Tweak the mapping by including /excluding certain scripts and databases from the group mapping.
- Execute all the selected scripts against all the selected databases based ont he mapping with one click.
- Get a comprehensive execution report with details on the execution of each script.
- View the result sets from all queries in one integrated interface.
- Save the deployment package configuration for future use.
- Generate self-contained executable that can be shipped to the end user who can now deploy the scripts to the target databases without any software or database knowledge.
- Supports SQL Server 2008/2005/2000 and MySQL 5.0/5.1
You can read more about Script Executor
here...