|
|
DBUpdater features
Provider Supported
The providers supported by the DbUpdater tool are:
- MSDE
- Sql Server 2000
- ASA 8 or superion
- Access (in development phase)
Basic
- Package database schema
- Live and off-line database installation and update
- Update all kind of database objects (tables, indexes, stored procedures, db spaces, users)
- Define which kind of object to update
- Define which kind of update to do (insert new objects, update existing objects, delete unused objects, rename objects, copy and/or delete data, exclude listed objects from update)
- Easy-to-use configuration files where define the update policy
- Easy-to-use visual tool for packaging
- Update policy specialized for single customer
- Customer provider different from development team provider
- Preserve dependencies and referential integrity during updating
Advanced
- DataBase Creation
- Upon primary key changes, automatic update child data by means of foreign keys
- Copy data from original table to customer table
- Rename tables
- Rename fields
- Update stored procedures and functions, even when they are encrypted
- Update triggers
- Delete unused tables, fields, indexex, constraints
- Support of different providers
- Synchronize database which are mounted in different providers
- Customer prefixes used to discard updates for some tables
- Automatic backup database before update
- Window for manual handling update sql script before run it
- Asks confirmation for object deletion
- Exact field mapping à solved problem with ADO schema info
- Clear (or partial delete) table content
- Customizable Console window
- Customizable Progress Info window
- Possibility to work in quite mode
|
|