DBScripter Ver. 5.0 Release Notes


The following are the changes that DBScripter has gone through since Ver. 1.0:

Ver. 1.0: 
Original Release.

Ver. 1.1:
Feature: Profiles for customization
Status: Added
Feature: Tutorial
Status: Added

Ver. 1.2:
Bug: Saving new profile from control panel not always worked
Status: Fixed
Bug: When saving a file in NT first few lines not saved
Status: Fixed

Ver. 2.0:
Feature: Ability to script indexes.
Status: Added
Feature: Ability to format data
Status: Added
Feature: Merge architecture with DBDiff for added functionality
Status: Done
Ease of Use: Update on-line Help
Status: Done

Ver. 3.0:
Feature: Optimize script output for structures (rearrange tables for better DB performance and efficiency)
Status: Added
Feature: Ability to decide when to put or omit field length for structure scripting
Status: Added
Feature: Ability to automatically translate Data Types to custom or predefined types
Status: Added
Feature: Ability to include 'tablename.' before index name in drop statement.
Status: Added
Ease of Use: Show previous columns in Columns to ignore (Advanced Options)
Status: Done
Ease of Use: Show previous tables marked for skipping in Advanced Structure Options
Status: Done

Ver. 3.1:
Feature: Added option to trim data spaces both left and right in Advanced Data Options
Status: Added
Bug: Tables marked for skipping were erased on next run if no advanced setup was done for next run.
Status: Fixed

Ver. 3.2:
Feature: Setup of functions while retrieving different data types
Status: Added
Feature: Ability to define functions to be placed on script for each data type.
Status: Added
Feature: Automatic detection of special named database objects
Status: Added
Bug: Some special characters caused a problem when retrieving data
Status: Fixed + See above feature.
Ease of Use: On-line help updated
Status: Done

Ver. 3.3:
Bug: The Unique Index String and Non Unique Index string were being swapped
Status: Fixed

Ver. 4.0:
Feature: Save settings for retrieval on next run
Status: Added
Feature: Create and load configuration files
Status: Added
Feature: Command line run ability
Status: Added
Feature: Ability to automatically add Commit statements in script
Status: Added
Feature: Ability to substitute strings during script generation
Status: Added
Feature: Profile Upgrade Utility
Status: Included in distribution
Bug: Retrieval of unwanted tables in SQLServer/DB2
Status: Fixed
Bug: Spelling mistakes in help file
Status: Fixed
Ease of Use: Added user name to database name
Status: Done
Ease of Use: Updated Help Files
Status: Done

Ver. 4.1:
Bug: Character truncation on long data fields
Status: Fixed
Bug: Installer failed to create entry in Start Menu
Status: Fixed
Bug: Performance while scripting large amounts of data
Status: Order by is no longer used thus saving time and space in the database
Feature: Multi-user database auto detection
Status: Now DBScripter automatically identifies and handles such databases
Feature: Ability to specify values for empty (null) strings
Status: Added
Feature: Ability to save report in RTF format
Status: Added, now report can be saved preserving the colors.
Ease of Use: Added server name to database name
Status: Done
Ease of Use: Updated Help Files
Status: Done

Ver. 5.0:
Ability to "switch" user/owner/schema within database, it is no longer required to log on as owner, permissions are enough
Added ability to unlock read-only property to allo user to modify generated script
Modified UI for ease of use, including control panel
New option to rerun last script
Ability to differentiate by profile between NULL and empty strings
New feature to output data as CSV instead of insert statements
Added ability to add and test conditions for the retrieval of data
Ability to open/save/save as configuration files.
Configuration files are now editable ASCII files 
New option to execute free form sql to generate sql scripts
Added SQL Library for easy access to common sql statements
Script functions can now be automatically disabled for null and empty strings
Added processing for "wide" character data types
Ability to change report fonts
Restore window size and position
Ability to Close the DBScripter parameters window without having to start script generation
Modified Oracle Default profile
Profile and Advanced properties dialogs now "remember" last location (ease of use)
Corrected "onupdate" option for toolbar buttons
Location problem when creating new profiles, sometimes they would not show on next DBScripter run
Fixed problem when no "readable" profiles were available
General ease of use items (window focus, default values for edits, etc.)
Fixed problem where under some circumstances the length was being ommited during the structure script
Updated Help Files