SQL Schema Sync - Summary

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Summary

SQL Schema Sync by Perpetuum Software

URLs: sql-schema-sync, sql schema sync, sqlschemasync, perpetuum

Save time keeping databases in sync with this Database Synchronization Utility. SQL Schema Sync – Application is a utility designed for developers and database administrators who work with MS SQL Server 2005 and MS SQL Server 2008. The product allows the fast, simple comparison and synchronization of two databases with zero errors.

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.

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.

Please note that SQL Schema Sync is now an open source project and no longer available to purchase.

For more information please go to http://sqlschemasyncapi.codeplex.com/

Save time keeping databases in sync with this Database Synchronization Utility.

Evals & Downloads: Read the SQL Schema Sync User Guide

Operating System for Deployment: Windows 7, Windows Server 2008, Windows Vista, Windows XP

Architecture of Product: 32Bit

Product Type: Application

Compatible Containers: Microsoft SQL Server 2008, Microsoft SQL Server 2005

Keywords: SQL Schema Sync synchronize synchronizing data databases

Perpetuum Software Perpetum 9Rays.Net

Database DB Management

SQL query language