What's New in SQL Schema Sync API
SQL Schema Sync API 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.
Database Restyle – Library 1.7 (04.17.08)
Database Restyle – Application:
New: Localization languages:
Improved: Handling of errors occurred when saving database snapshot to a file;
Improved: Detailed description of error when unhandled exception arises;
Improved: Database reverse and synchronization is executed in a separate stream, so it is possible to pause or abort these operations;
Fixed: Connection to server using Sql authentication;
Database Restyle – Library:
Fixed: Comparison of users with unset default schema.
Database Restyle – Library 1.6 (03.27.08)
New: Synchronization of relations between .Net assemblies in the database model is implemented;
New: Synchronization of database permissions appeared;
New: Database Restyle – Application provides the ability of visual synchronization of LINQ To SQL model with database structure. A new data source in the form of .Net assembly containing DataContext descendant types added to the utility;
New: New localizations for the Database Restyle – Application utility:
- French;
- Italian;
- Portuguese;
- Romanian;
- Thai;
- Vietnamese;
- Finnish;
Improved: Database synchronization is executed within a single transaction. Only binding and unbinding of users membership in roles is executed out of transaction.
Improved: New logic of converting data in columns. Now data is always converted if types are cast;
Fixed: In function of LINQ To SQL model synchronization, relations are established if tables are located in different schemas;
Fixed: Reverse of triggers is executed even if they are encrypted;
Fixed: Synchronization of triggers related to views.
Database Restyle - Library™ 1.5 (02.19.2008)
New:Visual tool providing the ability to save database snapshot, compare two databases and synchronize them. Database
Restyle can work in the wizard mode: convenient and intuitive interface allows execution of mentioned tasks by just a few mouse
clicks.
Database Restyle - Library™ 1.1 (12.13.2007)
New: Ability to convert LINQ to SQL Classes model to Database-typed objects (PerpetuumSoft.DataModel.LinqToSql.dll). Now it is possible to use Linq to Sql model as well as any other existing database schemas as initial database structure. A couple of lines of code are enough to create or update database.
New: Supported objects:
- Tables (columns, primary keys)
- Relation between tables (external keys)
- Functions and stored procedures
- Schemas
Added: Example demonstrating how to convert LINQ to SQL classes to Database (C#/VB).
Requirements: .Net Framework 3.5 is required for PerpetuumSoft.DataModel.LinqToSql.dll
Database Restyle - Library™ 1.0.5 (12.04.2007)
New: Support for new objects:
- Rule;
- Default;
- Database options;
New: Sample demonstrating how to easily create database structure based on business objects;
Improved: Existing samples.
|