Database Restyle - Library generates script to synchronize database structure directly from your application; there is no need to install third-party software or release patches. Synchronization is performed by the component, it is just necessary to invoke the Update method with connection to the database. Database structure is saved as XML file and can be distributed in any form (file, resource, etc.).
Synchronized database objects
Schemas
Tables
Views
Functions and stored procedures
Triggers
DLL triggers
DLLs
Custom types and CLR types
Indexes and XML indexes
XML schema collections
Constraints
Users, roles and permissions
Extended properties
Product Features:
Ability to perform additional actions in case of sophisticated refactoring of database structure;
Ability to create database structure from application code, for example, on the basis of business objects and synchronize it with MS SQL Server;
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.
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.
Ability to save database schema as XML file;
Automatic definition of scripts performance order subject to dependencies between objects.
Integration directly into your application;
Works with applications of any type: WinForms, WebForms, console applications, services, WPF applications;
Synchronization with a database of any structure on the client side;
Ability to build the synchronization functions in your application;
Royalty-free runtime; no additional fees;
Contains only managed .Net code;
Developed for SQL Server 2005;
CommandLine component and instrument are included;
Full source code is available;
Database Restyle delivery package provides a sample application, illustrating the simplest scenario of the component use.
Database Restyle - Library is available in the following editions:
Standard Edition - intended for Windows Forms, ASP.NET, WPF and console applications;
Professional Edition - intended for Windows Forms, ASP.NET, WPF and console applications. The Database Restyle - Library Professional edition comes with full source code.
Download Trial/Demo Downloads: 324 |