Recommended: Click here to run a Free driver update scan »
Typically, SQL developers make plenty of changes in a development database beforetransferring them to a production database. This process is tedious since it takeshours of intensive scripting by hand. Besides, it often involves long debugging iferrors occurred during the transfer. SQL Examiner, coupled with SQL Data Examiner,allows developers to automate the schema and data comparison and synchronization, sothat a production database fully matches a development one and has no missingstructure elements. Developers can take advantage of wide opportunities inconfiguring synchronization parameters to make synchronization script meet theirrequirements. When a script is being prepared, all links between objects and dataare traced automatically, which is difficult to do manually. It is enough to selectonly one object and all the objects dependent on it will be included into theresulting script. The software has a clean and intuitive Office 2003/Visual Studio2005-style user interface, which can be customized to individual preferences of thedeveloper.
What is unique in SQL Examiner? - SQL Examiner, unlike competitors, supportsdifferent synchronization sources. When needed, you can use a backup or a detacheddatabase files or a snapshot as a source database. For your convenience, SQLExaminer 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 toa column, existing data will be checked for their uniqueness and a warning displayedif data fail to comply with the constraint; - When there are several ways of dealingwith 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 toa table with data, you will get a warning that it is impossible to add this columnand you will be able to select the conversion method that suits you best - eitheradd 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 Examinerprovides a Partial Synchronization mode that allows you to drill down to selectspecific columns within a table for a more fine grained comparison. Let's say, forexample, there are two columns that differ from each other by three columns and twoconstraints. In such a case, you can specify only two columns and one constraintduring synchronization.
Pricing and AvailabilitySQL Examiner 1.4 and SQL Data Examiner 1.0 are compatible with Microsoft Windows NT4.0, 2000, XP, 2003 and require Microsoft .NET framework. Two products aredistributed as standalone applications or as a single bundle with a considerablediscount. SQL Examiner costs $199.95 (USD) for a single-user license. Discounts forvolume buyers are available. Registered customers are entitled to premium technicalsupport, free minor updates and major updates with a considerable discount.Additional information on the products, detailed documentation, as well asevaluation copies can be found at www.sqlaccessories.com.
About TULASOFTFounded in 2003 by Michael Gerasimov, TulaSoft is an Information Technology companydeveloping value added software tools for Microsoft SQL Server. TulaSoft is theauthor of SQL Examiner, a high speed database comparison and synchronization tool,and SQL Data Examiner, a tool that compares and synchronizes SQL Server databasecontents and simplifies data migration. Over the last 3 years, SQL Examiner hasbecome the choice software for customers in 25 countries. TulaSoft is a MicrosoftGold Certified Partner, which acknowledges their status as a respected provider ofdevelopment tools, created in the spirit of Microsoft Software Development. For moreinformation, please visit www.sqlaccessories.com.
