Directories

SQL DATABASE COMPARISON & SYNCHRONIZATION SUITE FROM TULASOFT NOW FULLY SUPPORTS SQL SERVER 2005

2006-09-04

TULASOFT has announced the immediate availability of SQL Examiner 1.4 and SQL Data Examiner 1.0. SQL Examiner enables developers to compare the schema of two Microsoft SQL Server databases and quickly locate the changes in tables, views, stored procedures or any other object in the database. Coupled with SQL Data Examiner, this duet can also compare and synchronize data differences between the two databases. New to SQL Examiner 1.4 is an ability to compare and synchronize CLR-objects, which are now supported by SQL Server 2005.

Typically, SQL developers make plenty of changes in a development database before transferring them to a production database. This process is tedious since it takes hours of intensive scripting by hand. Besides, it often involves long debugging if errors occurred during the transfer. SQL Examiner, coupled with SQL Data Examiner, allows developers to automate the schema and data comparison and synchronization, so that a production database fully matches a development one and has no missing structure elements. Developers can take advantage of wide opportunities in configuring synchronization parameters to make synchronization script meet their requirements. When a script is being prepared, all links between objects and data are traced automatically, which is difficult to do manually. It is enough to select only one object and all the objects dependent on it will be included into the resulting script. The software has a clean and intuitive Office 2003/Visual Studio 2005-style user interface, which can be customized to individual preferences of the developer.

What is unique in SQL Examiner? - SQL Examiner, unlike competitors, supports different synchronization sources. When needed, you can use a backup or a detached database files or a snapshot as a source database. For your convenience, SQL Examiner compares a live database with a previous backup without even restoring it; - When SQL Examiner synchronizes the schema, it can take into account the data, stored in an updated database too. For example, when you add a constraint UNIQUE to a column, existing data will be checked for their uniqueness and a warning displayed if data fail to comply with the constraint; - When there are several ways of dealing with a particular issue, SQL Examiner offers you to select the conversion method. For instance, if you try to add a NOT NULL column without the DEFAULT limitation to a table with data, you will get a warning that it is impossible to add this column and you will be able to select the conversion method that suits you best - either add the column as allowing NULL values or write some default value in the new column (you can even use an SQL script to fill the column with data!); -SQL Examiner provides a Partial Synchronization mode that allows you to drill down to select specific columns within a table for a more fine grained comparison. Let's say, for example, there are two columns that differ from each other by three columns and two constraints. In such a case, you can specify only two columns and one constraint during synchronization.

Pricing and Availability
SQL Examiner 1.4 and SQL Data Examiner 1.0 are compatible with Microsoft Windows NT 4.0, 2000, XP, 2003 and require Microsoft .NET framework. Two products are distributed as standalone applications or as a single bundle with a considerable discount. SQL Examiner costs $199.95 (USD) for a single-user license. Discounts for volume buyers are available. Registered customers are entitled to premium technical support, free minor updates and major updates with a considerable discount. Additional information on the products, detailed documentation, as well as evaluation copies can be found at www.sqlaccessories.com.

About TULASOFT
Founded in 2003 by Michael Gerasimov, TulaSoft is an Information Technology company developing value added software tools for Microsoft SQL Server. TulaSoft is the author of SQL Examiner, a high speed database comparison and synchronization tool, and SQL Data Examiner, a tool that compares and synchronizes SQL Server database contents and simplifies data migration. Over the last 3 years, SQL Examiner has become the choice software for customers in 25 countries. TulaSoft is a Microsoft Gold Certified Partner, which acknowledges their status as a respected provider of development tools, created in the spirit of Microsoft Software Development. For more information, please visit www.sqlaccessories.com.

Related Downloads

dbForge Schema Compare for SQL Server

dbForge Schema Compare for SQL Server 4.0

dbForge Schema Compare for SQL Server is a reliable, easy-to-use tool for comparing and synchronizing Microsoft SQL Server database schemas. This product is specially designed to help you compare your SQL Server databases, analyze differences and...

Idera SQL comparison toolset 3.4

Quickly identify and synchronize data and object changes

- Perform SQL data compare and SQL schema compare tasks and synchronization
- Capture schema snapshots to preserve change history
- Synchronize SQL data automatically...

Omega Sync 3.3

This is the product to use when you want to explore all the differences in structure and data of your databases. You can even synchronize your databases in minutes, or save generated synchronization SQL script for later use. Omega Sync can compare...

SQLDBCompare V2.4

What is SQLDBCompare?SQLDBCompare is the powerful database schema/data comparison and synchronization tool for SQL Server database development projects. SQLDBCompare integrates with SQL Server, providing an effective and effortless database schema...

Datanamic SchemaDiff for MS Access 2011.0

SchemaDiff compares and synchronizes MS SQL database schemas.

Datanamic SchemaDiff for MS SQL provides the ability to compare and synchronize two MS SQL database schemas. After the comparison is performed, Datanamic SchemaDiff for MS SQL...

SQL Examiner Suite 1.2

SQL Examiner Suite meets all your SQL database comparison and synchronization needs. It is a fast, easy-to-use software suite that allows you to compare and synchronize schema and data. With just a few mouse clicks, you can quickly merge two...

Datanamic SchemaDiff for MS SQL 11.0

Datanamic SchemaDiff for MS SQL provides the ability to compare and synchronize two MS SQL database schemas. After the comparison is performed, Datanamic SchemaDiff for MS SQL generates the synchronization script that can be used to update the...

SQL Examiner Suite 2010 R2 4.1.0

SQL Examiner Suite 2010 R2 is a quick and easy-to-use software solution that enables you to compare and synchronize both schema and data. It covers all your SQL database comparison and synchronization needs, and fulfils any task on merging databases...

dbForge Data Compare for SQL Server

dbForge Data Compare for SQL Server 3.9

dbForge Data Compare for SQL Server is a powerful, fast and easy to use SQL compare tool able to complete any data comparison and synchronization tasks and provide the best professional tricks to easy your database management. You can quickly analyze...

SQL Comparison SDK

SQL Comparison SDK 8.0

The SQL Comparison SDK provides a means to compare and synchronize database schemas and data from within your own applications, with a greater degree of control than the command line interfaces.

It does this by giving you access to the...