SQL Schema Sync API™ Features

SQL Schema Sync API™ runtime is royalty-free.
This will help you significant sum of money, as you don’t need to purchase additional licenses for your end users and clients;

SQL Schema Sync API™ is integrated directly into your application.
There is no need to install extra software on the client side, this considerably reduces time and money expenses;

Works with applications of any type: WinForms, WebForms, console applications, services, WPF applications.
The component can be used in .Net application of any type;

Support for LINQ.
It is possible to use Linq to Sql model as well as any other existing database schemas as source database structure. A couple of lines of code are enough to create or update database. And the whole process from forming database object graph to executing DLL scripts is under the developer’s total control.

Synchronization with database of any type on the client side.
No need to track down sequence of patches and so on;

Ability to perform additional actions in case of sophisticated refactoring of database structure.
When it is impossible to carry data from a database of old structure directly to new database, it is necessary to copy data from database to temporary storage before database refactoring and to restore data after refactoring is complete. Such behavior can be realized with the help of the following events: DatabaseSync: DatabaseUpdating and DatabaseUpdated.

Ability to create database structure from application code, for example, on the basis of business objects.
No need to track correspondence of objects of application business logic to database structure. Application can easily reorganize database structure to the required one to get full correspondence to custom business objects.
It is also possible to create database structure in the application code and to carry it to MS SQL Server 2005/2008. Carry is performed by firing a single function.

Visual Wizard
Intuitive visual tool allows the snapshotting of database structure, comparison of databases and their synchronization. The work of the visual tool in the wizard mode provides user-friendly interface which allows quick saving of database snapshots, synchronization and comparison with a few mouse clicks. Saving and passing of the database snapshot simplifies and accelerates comparison and synchronization of databases on the client side.

Full source code is available;

Contains only managed .Net code;

Developed for SQL Server 2005/2008.
Support for latest innovations such as XML type, use of .Net assemblies, etc.

CommandLine component and instrument are included.
The delivery package includes the SqlSchemaSync.exe utility that performs operations of saving snapshot and updating database from the command line;

Ability to save database schema as XML file.
Such file can be stored in source control, easily transferred via the network and used to adjust database structure on the server in accordance with structure saved in it.

Automatic definition of scripts performance order subject to relations between objects.
When database structure is reversed, all relations between objects are read from SQL Server. This feature and built-in system of logical dependence provide the ability to perform scripts for database reorganization in the necessary sequence.

Supported objects.
Schemes, Tables, Views, Functions and stored procedures, Triggers, DLL triggers, Assemblies, User-Defined types and CLR types, Indexes and XML indexes, XML schemes collections, Constraints, Users, roles and permissions, Extended properties.

Download SQL Schema Sync API™...