SQL Schema Sync

Database Restyle - Application was rebranded as SQL Schema Sync

What's New in SQL Schema Sync

SQL Schema Sync 1.0.0.0 (11.16.2009)

New: Full support for MS SQL Server 2008.
New: Ability to work with new data types:

• DateTime2;
• DateTimeOffset;
• Date;
• Geometry;
• Geography;
• Hierarchyid
• Time.

New: Ability to use Spatial indexes.
New: Simple comparison logic in a predicate in a WHERE clause for the creation of relational index or view for a specified table.
New: Ability to use SPARSE columns and column sets to optimize the work with NULL values.
Improved: Work with stored procedures and user defined functions:

• Ability to define parameters;
• Use of CLR Table-Valued Functions;
• Use of Order by Clause.

New: Table Type which can be defined by a user.

SQL Schema Sync – Application has the following benefits:

• The utility is designed as a Wizard. You won’t have to work with complicated menus and a great number of buttons. The Wizard will suggest what to do at every step
• The product provides visual synchronization of LINQ To SQL model with database structure, using .Net assembly as a data source
• Database Restyle – Application allows saving the database structure not in the binary format, but in the form of an XML file. Now, if necessary, you can read or modify the file structure by yourself
• The utility provides full control over synchronization by setting the synchronization options. You can also skip specific objects during synchronization

SQL Schema Sync - Application supports the following objects: schemas, 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.

SQL Schema Sync - Application Features

Final Application.
SQL Schema Sync - Application is a tool which can be used by both database administrators and developers.

Wizard.
SQL Schema Sync – Application is designed as Wizard which advantageously distinguishes it from the competitive products. You don’t need to choose among great number of operations, steps and opportunities. SQL Schema Sync – Application Wizard will allow you to execute all operations on synchronization step-by-step without breaking operational logic.

Intuitive user-friendly interface.
Comprehensive program interface allows the non-IT personnel or developers to quickly examine program functionality and execute all operations as you go.

Saving database snapshots.
Saved database structure snapshots can be compared, analyzed thus providing a complete history of changes for keeping versions history or roll-back purposes.

Comparing database structures.
SQL Schema Sync - Application™ allows automatic comparison of two database structures. The results of database comparison are displayed in a table thus enabling the user to examine the differences between databases and select the objects to be synchronized.

Synchronizing database structures.
Automatic generation and execution of the scripts for database structure synchronization saves from doing complicated manual work.

Saving scripts for further use.
It is possible to save the generated script for its modification or optimization. It is also possible to use the saved script for manual database synchronization.

Ability to quickly synchronize and compare database structures on removed servers.
Besides that, passing of the snapshot considerably accelerates the synchronization of two databases on removed servers.

Easy-to-use solution.
SQL Schema Sync - Application is extremely easy to use. Almost every procedure can be executed with few mouse clicks thus eliminating the need to examine the program architecture.

Support for all database objects.
SQL Schema Sync - Application supports the following objects: schemas, 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.

Developed for MS SQL Server 2005 and MS SQL Server 2008.