Oracle
Fixed error when comments included single quotes. Xcase will replace them with two quotes when submitting to the database.
Fixed script error when renaming an index.
MySQL 5
The length of Varchar columns in MySQL 5 models can now be set to a value up to 65536.
When modifying the type of a Primary Key, the generated script now first deletes outgoing relationships to allow the modification and then restores them at the end of the script.
SQL Server 2005
When modifying the type of a column having a default, the generated script now first deletes the default to allow the modification and then restores it after modifying the type.
Fixed script error when modifying a Foreign Key.
VFP
Modifying an Index from Regular to Candidate was not detected.
When a View is flagged as non AutoSQL, if View Columns are defined in the model, they are now used to update the DBC View Column attributes.
The View Column property "UpdateName" is now properly set for Expressions and tables with spaces in their Long Names.
General
Fixed license key and Data Dictionary update issues on 64 bit Windows Operating Systems.
Fixed syntax errors on the generated XML schema.
Compatibility
Version 8.1 can open models created with previous versions of Xcase, but you should not attempt to open an 8.1 model with previous versions including Version 8.
What’s new in version 8
Full support for Microsoft SQL Server 2005
Including: Schemas, Partitions, XML collections, XML Indexes, Index Included Columns, Description Extended Property, CLR Objects and much more.
Full support for MySQL 5
Including: Views, Stored Procedures, Functions and Triggers.
Redesigned Workspace
Redesigned customizable and powerful XP style Toolbars
The Toolbar has been redesigned in the XP style. It comprises the following groups of tools, File, Edit, Database, Model, Display, Zoom, Adjust, Shapes.
New Main Menu Structure
New Multi-select Ability in the Synchronize and Merge Dialogs
In the Sync and Merge Dialogs, it is now possible to select multiple discrepancies in the displayed list. It is then possible to apply an action to all the selected items at once.
Redesigned Browsers & Inspectors
All browsers and inspectors have now been logically regrouped in multi-tab specific Browsers, so that all the settings relevant to a given task can now be performed without having to go back and forth between menus and Browsers.
Redesigned Physical Data Browser
The Physical Data Browser has been completely redesigned. For each Parent Entity in the upper pane, it now shows all the Child Entities in a tabbed browser in the lower pane.
Easier handling of the Message Log Window
Clear and Show Messages accessible from the Window menu have now been regrouped into a single Message Log window.
Redesigned Dialog boxes
All the Dialogs have been redesigned in the XP style. Some Dialogs have been split in order to have a clearer view of the various actions and more logical groupings.
Redesigned Xcase Help
The Xcase Help System has undergone complete reshuffling. It now uses the compiled HTML Help format. Many screen shots and pictures have been added to make it more intuitive and efficient. The text has been revised to make it even more clear and concise.
New Select Data Dictionary Object
This new feature allows selecting Data Dictionary Objects Names in the Code Editor. If you are in the middle of typing an Entity or View name, or a qualified column name, pressing F3 will allow you to select it in the Dialog and it will be auto-completed.
New Align feature
The Align opens a dialog box that allows you to align all the selected Entities horizontally and vertically in addition, it includes a space equally function.
New Dynamic Zoom
The Dynamic Zoom Tool allows you to increase or decrease the zoom level of the display by clicking the left mouse button and dragging it on the workspace.
New Fit to Program Window
This function fits the current diagram to the Program Window. This is much more efficient than using the usual Maximize or Tile standard features, without their drawbacks.
New Fit to Window
This function re-sizes the entire Display to have it fit in the Display Window. If a Marquee is active when you click the Fit to Window button, it will apply to the Marquee rather than to the whole Display.
New Hand Tool
The Hand tool allows you to easily grab and move the display around to focus on the part you are interested in.
New Hotkeys
New Make not-null Bold
This option of the Display tab in the Settings dialog allows you to emphasize fields that cannot be null by having them displayed in bold within the Entity.
A New Diagram
You can now create a new diagram based on the current one by right-clicking on an empty space and selecting the New Diagram option from the pop-up menu.
New ODBC Setup
Clicking the Synchronize Database with Model option, opens the Connect to ODBC Source, this now features a Setup button that opens the ODBC Data Source Administrator from within Xcase.
Redesigned Reports
The listings of the data dictionary objects in Model Reports have now a Comments column. In addition, if the descriptive name (title) of an object differs from the physical name (name), it will be displayed after the name.
Redesigned Relational Integrity Logic
When creating a New Model, the Model Settings Dialog allows defining the Referential Integrity Implementation. This determines the default Referential Integrity implementation at Model level, and can be overridden at relation level in the Referential Integrity dialog box, available from a right-click on a relation.
New Display Settings
This option accessible from the View menu opens a dialog box that allow you to easily set modify the settings of the Display. The dialog can also be opened by clicking the Display icon. Their Defaults can now be set.
New Straighten Line
This function is available when you right-click on a relationship connecting line between two entities. It automatically straightens the line instead of you having to try to drag it to the required position.
What’s new in version 7.5
Support For Visual Fox Pro 9
Xcase Pro, Xcase For Fox and Xcase Viewer now fully support Visual
FoxPro 9. In VFP models, you can now use the following new types:
varchar, varchar binary, varbinary, and blob.
Support For MaxDB
Xcase Pro and Xcase for MaxDB now support MaxDB.
The complete list of new feature and functionality will be published
later.
What’s new in version 7
Model Archive and Version Control
You can create multiple archives of a model. You can compare a
model with one of its archives. Based on the results of the comparison,
you can update the model according to the actions you set.
Model Compare and Merge
You can compare and merge any two models, even if they do not
share the same DBMS. This allows you to easily maintain multiple
models targeting different DBMS.
Enhanced Code Editor with Syntax Coloring
Xcase 7 features an enhanced code editor with syntax coloring.
Parsing of Reverse Engineered Views
Xcase 7 allows you to parse Reverse Engineered views so they can
be easily edited and auto maintained as you make modifications
to your model such as changing field and table names or foreign
keys.
Support for Oracle User Defined Types
Xcase 7 fully supports Oracle User Defined Types.
Support for Sequences in Oracle
Xcase 7 allows you to reverse engineer, create and alter Sequences.
A Sequence can be assigned to a field and the automatically generated
"Before Insert" Trigger generated by Xcase for the entity containing
the field, will handle the update of the field with a proper value
from the Sequence.
Model Level Attribute Defaults
Xcase 7 not only allows you, like in previous versions, to set
default values for all the attributes in the model, but also allows
you to set them at model level.
Better Control of Preference Settings
In Xcase 7 you no longer have to edit an ini file in order to
control preferences. You can set preferences from within Xcase
in the new tabbed "Preferences" dialog box.
Better Control of Key Migration
You can set foreign key migration rules when creating a model.
You can modify foreign key migration rules when working on a model.
You can set foreign key migration rules when reverse engineering
tables.
Support for Multiple Database Object Owners
Xcase 7 allows you to manage, within the same model, database
objects belonging to different owners.
Support for Functions in Oracle and SQL Server
models
Xcase 7 supports the reverse engineering, the creation and the
alteration of functions in Oracle and SQL Server models.
Enhanced use of Mouse Wheel
You can use the mouse wheel to zoom in and out of a display and
to shift a display to the left or right.
Delete Objects from Tree View
In previous versions of Xcase, an object could be deleted only
if it was present in the current diagram or by using the browsers.
In Xcase 7 you can also delete an object from the Navigation Tree.
Support for Model Level Custom Trigger Templates
You can create global trigger templates and assign them to entities.
The defined templates can be used in all models sharing the same
DBMS.
What’s new in version 6.5
Support For Visual
Fox Pro 8
Xcase Pro,
Xcase For Fox and
Xcase Viewer now support Visual FoxPro
8. In VFP models, you can now use the new Integer AutoIcrement
type and set its Step and Next Value attributes. Stored procedures
can be compiled as VFP 8.
Free Upgrade to the Next Release of
Xcase: Version 7
If you purchase or upgrade to version 6.5, you will be entitled
to a Free Upgrade to the next version of
Xcase which will be released
at the beginning of the second quarter of 2003. The following
is a partial list of the new features and enhancements of version
7:
- Version Control and model Archive
- Model Compare and Update across different DBMS
- Reverse Engineer Views, so that they can be Auto Maintained
in the model
- Enhanced Code Editor with Syntax Coloring
- Support for multiple database object owners in a model
- Model Level Attribute Defaults
- Better control over key migration and RI setting
- Support for multiple instances of Xcase running simultaneously
on the same computer
- Enhanced Scripting Language allowing to update model attributes
- Greatly enhanced support for Oracle including User Defined
Types
- Enhanced GUI
- Enhanced UI
- Enhanced Speed
What's new in version 6.1
InterBase 7
Xcase Pro and Xcase For InterBase now support InterBase 7. If
the DBMS of your model is 'InterBase 6 Dialect 3' you can now
use Data Base object Names up to 60 character long and use the
new Boolean data type.
Support for MySQL
Xcase Pro now supports MySQL. If you own a DBMS specific version
of Xcase, you can upgrade to Xcase Pro or purchase Xcase For MySQL
(supporting only MySQL).
Fixed in 6.1
General
- Selecting a display custom background does not consume memory
resources
- Searching an entity using Edit / Go To now selects it
- Fixed problem when exporting a report to PDF or RTF format
- 'Delete Model' no longer removes non-Xcase files from the
model folder
- When editing the RI settings or Relation Title, the display
now refreshes correctly
- Hidden relations for embedded diagrams no longer reappear
when re-opening diagram
- Declarative 'On Delete Cascade' no longer incorrectly reported
as a model/DB discrepancy
- Stored Procedure templates no longer incompletely expanded
in scripts
- When a domain attribute is modified, the dialog no longer
displays Objects ID instead of names
VFP
- Logical Field doesn't cause an error in createdb.exe
- View elements are now properly maintained in views with 'select
*'
- Foreign Key name is now set according to the setting in Xcase.ini
- The View 'Tables' property is now correct when two or more
table names start with the same string
- In SQL statements Tables of Multiple DBC views, fields are
now properly aliased
- Remote VFP views no longer use the Title of the entities instead
of the Name
Oracle
- Declarative 'Cascade Delete' is now properly reverse engineered
- Removed blank lines from generated scripts (caused problems
when not submitted via Xcase)
Interbase
- In triggers using 'Expand Template' the 'As' keyword now appears
- Input and Output parameters of stored procedures are properly
reverse engineered when the database is defined with a non-default
Character Set
DB2
- Fixed UDF memory error when reverse engineering indexes
SQL Server
- When 'Copying Model with different target DBMS' from SQL Server
7 to SQL Server 2000, some data types did not convert correctly.
This was fixed.
- Foreign Keys now correctly inherit the Rowguid property of
the parent Primary Key
- Fields are now reverse engineered in their 'Natural' order
- The 'Copy Table' script will not delete the original table
if inserting into the temporary table is not successful
- System views are no longer reverse engineered
What's new in version 6.0
General
Views as graphic objects
In a display views can now appear as graphic objects. You can
drag them from the tree in to the display or make them appear
by adding them in to a diagram (Diagram / Diagram Elements).
Order Clause in Views
You can now select in the Order Clause of a View, columns that
are not part of the selected columns by clicking the "More
columns:" button in the "Order view elements" dialog.
Hide / Display Relations
You can now hide relations from a display. To Hide or Display
all relations in a display, select from the main menu "Display",
"Hide relations" or "Display relations". To
hide specific relations you can also select them and press CTRL
+ H. Right clicking on an Entity and selecting "Hide / Display
Relations" produces the "Hide / Display Relations"
Dialog box which allows to selectively hide or display the relations
of the Entity.
Locate objects in multiple diagrams
An entity a View or an Embedded diagram can appear in more than
one diagram. The new "Go To" dialog (Edit / Go To) allows
you to display a list of diagrams were an object is located. Double
click on the name of the diagram that contains the object in order
to open it and position the mouse cursor on top of the selected
object.
Display domain names in diagram
If a field is assigned to a domain, you can now view the domain
name in the display when the "Display Physical Attributes"
icon is pushed in the display tool bar.
Return to previous diagram
If you switch between diagrams or if you open an embedded diagram
you can now return to the previous by selecting Diagram / Previous
Diagram or by pressing Ctrl + P.
Crystal 8.5
The reports are now compiled with Crystal Reports 8.5. They run
faster and there are new and enhanced export options such as export
to PDF, XML and HTML.
Margins Control
In File, Print, Setup you can set margins for printing diagrams.
SQL Databases
Sync on ALL database objects
The Synchronization process now works on all database objects
allowing to detect differences between all model and database
objects including "code" objects.
The "Select Database Objects to Synchronize with Database"
now allows you to select in addition to entities:
Domains
Rules
Defaults
Views
Procedures
Triggers
Not that some of these options might be disabled depending on
the capabilities of the target DBMS.
Reverse engineer from Sync
The "Synchronize Database with Model" dialog now allows
you to select the "Import" action. This will reverse
engineer the selected object in to the model when you decide that
the value in the database is the proper one. Note that this option
should be used when the database engine writes into the database
metadata a modified version of the code submitted in the generated
script so that no discrepancy will be reported.
Discrepancy Report
In the "Synchronize Database with Model" dialog box
the "Preview / Print Report" button produces a detailed
report of the discrepancies found between the Model and the Database.
This report can be previewed on screen, printed or exported in
various formats.
Multi Event Trigger Support
Triggers for multiple events such as "Insert or Delete or
Update" are now supported on SQL Server 7, SQL Server 2000
and Oracle.
Oracle Comments
Oracle Comments on Database objects are now forward and reverse
engineered.
InterBase Default and Check
There is no more need to include the Default and Check keywords
when defining Defaults or Check Constraints in InterBase.
VFP
Xcase Version 6 radically changes the way VFP databases are handled.
Reverse and forward engineering of DBCs is now completely executed
from within the Xcase environment without switching to VFP itself.
VFP Free Tables are now fully supported (in previous versions
only Fox2.x Free Tables where supported).
A VFP model can handle multiple DBCs. In addition, the model
can contain Free Tables in VFP or Fox2.x format. The model can
also contain "Attached" tables in order to create Remote
Views, but in a non-VFP model, you can also define Connections
and Remote Views and generate a DBC for those Remote Views which
is the most efficient way to handle remote views.
Models with multiple DBCs allow you to create a separate DBC
for Views. They allow you also to generate Referential Integrity
and Views involving more than one DBC and Free Tables.
Xcase allows you to select which model objects will be checked
against the databases and to view the discrepancies found. You
can now decide on the appropriate action to take including the
possibility to Reverse Engineer a particular object into the model.
Views are now automatically Reverse Engineered into the model
except for View Fields.
Fixed in 6.0
1. Under some circumstances an incorrect message on insufficient
space available to create a model was produced.
2. The "Copy Table" code generated for tables containing
"Virtual" Foreign Keys in SQL Server was incorrect.
3. The "Copy Table" code generated for tables containing
Not Null TimeStamp fields was incorrect in SQL Server.
4. Fixed problem that occurred when attempting to move a relation
connecting two distant entities.
5. When copying an entity its "Name in Database" was
copied as well, leading to incorrect discrepancy results.
6. The generated scripts for code objects (Triggers, Stored Procedures)
contained superfluous Carriage Returns. This caused problems with
some RDBMs.
7. The "Copy Field" script in InterBase sometimes used
an incorrect field type.
8. Modifying a Connection Name from Upper to Lower case produced
a message stating that the name already exists in the Model.
9. DDL statements for Declarative Referential Integrity were
incorrect when set to "No" at relation level.
10. The length of Numeric and Float fields was sometimes incorrectly
reverse engineered in Oracle models.
11. The existence of TableSpace objects was incorrectly checked
in Oracle models unless the name was in Upper case in the model.
12. When copying a Display, Embedded Diagrams were not copied.
13. Internal indexes generated by the Statistics command in SQL
Server were reverse engineered.
