Provides the ability to construct database structure programmatically Making changes to the database structure is one of the most tedious and routine operations a developer of corporate applications faces to. The necessity of frequent updates considerably delays implementation of the project.
Existing tools solve this problem not 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.
Database Restyle offers a new solution of this problem. First of all, it's not an application; it is a component integrated directly into your application. This allows you not to install additional software on the client side and not to develop patches.
Synchronization is performed by the component, it is just necessary to 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 XML file and can be distributed in any form (file, resource, etc.).
The Database Restyle application will provide the ability to construct database structure programmatically (for example on the basis of business objects structure). Alterations in business objects will be automatically reflected in the database schema.
Thus, Database Restyle helps you reduce expenses for database deployment and exclude errors; it also prevents you from development routine. The use of the library doesn't require training, as in most cases it is necessary to invoke only two methods: the Reverse method gets database structure on the developer side and the Update method synchronizes database on the client side. The reverse procedure can be performed by the CommandLine instrument in the project PreBuild event. So, building of the application is completely automated and the inclusion of a new database schema is guaranteed.
Here are some key features of "Database Restyle":
Database Restyle 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;
Database Restyle 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;
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. Carry is performed by firing a single function.
Full source code is available;
Contains only managed .Net code;
Developed for SQL Server 2005.
Support for latest innovations such as XML type, use of .Net assemblies, etc.
CommandLine component and instrument are included.
The delivery package includes the DatabaseRestyle.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
Requirements:
SQL Server 2005, .Net Framework 2.0
Database Restyle
Check Discount]
Web developer s help
Web Server Management Software
xPML™ Mobile and Web Developer