by Perpetuum Software - Product Type: Component / .NET Class / 100% Managed Code
Please note that SQL Schema Sync API is now an open source project and no longer available to purchase.
For more information please go to http://sqlschemasyncapi.codeplex.com/
Automatic database synchronization with a royalty-free .Net component. SQL Schema Sync API is a component designed to automatically synchronize database structure. SQL Schema Sync API can integrate directly into applications and installation of additional software on the client side or development of patches is not required. The component is compatible with applications of any type: Win, Web, Console, Service, and WPF. SQL Schema Sync API provides developers with the ability to create the database structure programmatically, for example, based on business objects structure. Support for LINQ to SQL object model is provided. Full source code is available in the Professional edition. The component is developed for SQL Server 2005/2008 and contains only managed code.
Database Restyle - Library was rebranded as SQL Schema Sync API
New features in SQL Schema Sync API
New: Full support for MS SQL Server 2008.
New: Ability to work with new data types:
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:
New: Table Type which can be defined by a user.
SQL Schema Sync API - Automatic database synchronization.
Making changes to the database structure is one of the most tedious and routine operations a developer of corporate applications faces. The necessity for frequent updates considerably delays implementation of the project.
Existing tools do not solve this problem to the full extent, as most cases demand manual work, installation of expensive software for the synchronization of databases on the client side as well as development of patches for every alteration in the database structure.
SQL Schema Sync API offers a new solution to this problem. First of all, SQL Schema Sync API is not an application; it is a component integrated directly into your application. This allows you to avoid having to install additional software on the client side and means you do not need to develop any patches. Synchronization is performed by the component, all you need to do is invoke the Update method with connection to the database. You can distribute the component within your application without any additional fees, regardless of the application type (WinForms, ASP.NET, Console, WPF, etc.). Database structure is saved as an XML file and can be distributed in any form (file, resource, etc.).
It is possible to use the Linq to Sql model as well as any other existing database schemas as the initial database structure. A couple of lines of code are enough to create or update the database and the whole process from forming database object graphs to executing DLL scripts is under the developer’s total control.
SQL Schema Sync API provides the ability to construct a database structure programmatically (for example on the basis of business objects structure). Alterations in business objects will be automatically reflected in the database schema.
SQL Schema Sync API helps you reduce expenses for database deployment and exclude errors; it also releaves you from development routine. The use of the library doesn’t require training, as in most cases it only requires you to invoke only two methods: the Reverse method gets the database structure on the developer side and the Update method synchronizes the database on the client side. The reverse procedure can be performed by the CommandLine instrument in the project PreBuild event. Building the application is completely automated and the inclusion of a new database schema is guaranteed.
SQL Schema Sync API is an essential solution for the projects where database structure is completely defined by business objects structure. A designed procedure, forming database structure as objects graph based on metadata and business objects of your application subject to your task specific and used mapping tools, will solve the problem of database synchronization once for all.
SQL Schema Sync API is developed subject to requirements of DBAs and SQL developers. The visual tool included in the delivery package works in a wizard mode and is designed to save database snapshots, compare and synchronize two databases. The user-friendly and intuitive interfaces provided to the developer helps them execute all operations in minutes. Thus, developers can synchronize databases directly from their application or via a standalone tool.
The product is developed for SQL Server 2005/2008, .Net Framework 2.0 and contains only managed code. Professional version is delivered with full source code.