Release History :
What's new ?
No features documented for this version.
Support for SQL Server 2016 and 2017 has been added
The Entity attribute “Is Temporal” allows to set a table as temporal. When checking this attribute, the associated system period columns can be automatically created. You can set in the “Temporal History Name” Attribute the desired name for the history table. When browsing the physical data of a Temporal table, the data of the associated Temporal History will be displayed in the child browser.
A domain defined in a model can be set as a “Database Domain” in which case it will be synchronized with the database. If the “Database Domain” attribute is unchecked, the domain will be used only in the model and no synchronization with the database will occur.
Instead of Triggers can be defined for views. To access them, click the “Triggers” button in the Edit View dialog. They can also be accessed in the “Instead of Triggers” Tab of the Data Dictionary Browser.
When an index includes Geography or Geometry columns it will be automatically created as a spatial index. Also, in the Index Browsers you can set the “Spatial Index Parameters” in a new attribute.
In the Index Browsers you can set the “Included Columns” in a new attribute.
In a Browser displaying Metadata you can check multiple lines, then right click a row and in the menu that appears select “Export Selected Lines”. After setting the name of the export file, a dialog will appear allowing you to select the attributes of the lines which will be exported.
You can add Entities into the current diagram based on their Attributes. From the main Xcase menu select Code, Custom Scripts and Reports. You can customize the Template of the Job named “Add Entities to the Current Diagram”.
In the Entity and View bowsers and Inspectors the “Default Color” Attribute allows you to set a Color for the Entity or View. This will color will be set as the default color in all the diagrams where the object appears.
When an Entity is a parent of many other Entities and you which to disable in the children the display of the Foreign Keys originating in that parent Entity, the new Entity Attribute “Do Not Display FK in Children” allows you to do so.
A new setting has been added to the “Display Settings” Dialog and in the Display Tab of the “Settings” Dialog to allow display the virtual column definitions in the diagrams.
A new Entities Browser has been added. This Browser displays the Entities of the model and in the bottom sections, in multiple dedicated tabs, the related information such as Fields, Indexes, Constraints…
Xcase Pro makes it possible to generate quality test databases. The source of the data can be set to a wide variety of options (Existing Database, PC File, List of values, Synthetic Data…). Xcase uses the relationships defined in the model in order to generate coherent, yet compact and comprehensive databases where sensitive data can be obfuscated. This feature is currently available for SQL Server, Interbase Dialect 3, Firebird Dialect 3 and MySQL 5.
Support for SQL Server 2014 has been added.
It is now possible to display for each domain the columns using it and to assign columns to a different domain. From the Xcase main menu, select Dictionary, Domain usage. The Domains Usage browser displays a parent-child window. The top pan displays the domains defined in the model and the bottom pan displays the fields using the selected domain in the top pan. When modifying a domain attribute, Xcase will propose to cascade the modification into the fields using it. You can also modify the domain of a field in the bottom pan. If multiple fields have been selected, Xcase will ask whether the new domain assignment should be done for all the selected fields.
It is now possible to edit the physical data of a table using a View. If the View involves more than one Table, only one Table can be updated. To set which table can be updated, right click a View and select Edit. This will produce the View Diagram. In the View Diagram, right click an empty space and from the menu select ‘‘Set Updatable Table’’. By default the first table added to the view is set as updatable. Note that for this to work, the view must contain all the columns defining a Unique Key for the Updatable Table (Primary, Alternate (Unique Constraint) or Unique Index).
When displaying the Physical Data of a Table, a Window with up to 3 sections is now displayed. In the middle section the data of the main table is displayed. If relationships outgoing from the main table exist, the bottom section will display the data of the children tables in multiple tabs. If relationships incoming into the main table exist, the top section will display the data of the parent tables in multiple tabs.
Support for SQL Server 2012 and SQL Server Azure has been added
The interface for the creation of Views has been completely revised. Relationship paths can now be defined using a Graphical User Interface. Paths can now be defined between views not just between tables.
When a diagram has many tables, you can now automatically decompose it in multiple embedded diagrams. Each embedded diagram contains a cluster of closely related objects. To do this, select Diagram Cluster from the main menu.
In all the windows displaying code (views, procedures, triggers) typing Ctrl+Space will bring the data dictionary dialog allowing you to select an object and insert its name. In addition, when typing a dot following the name of an alias or a table, a list of its fields will be presented.
You can now right click a table, view or procedure in the diagram or tree to synchronize the database object with model object.
A new button ‘‘Select Objects’’ in the Synchronization dialog lets you change the objects list to synchronize, without needing to exit the dialog.
You can now select multiple lines in the browsers (objects editors). When updating or deleting a line, if more than one line is selected, the operation can be performed on all the selected lines. Selection is done by clicking or dragging the mouse on the right-most columns on the browser.
When a model includes objects from different schemas or owners, this can be displayed as a qualifier of the object in the display and in the tree. To set this for the current display, in the Display Settings dialog, check "Display Schema/Owner". To set the default behavior for newly created displays, select Options, Settings and in the Display Tab check "Display Schema/Owner".
When the code of a Stored Procedure in SQL Server 2008 is not the same in the model and in the database, Xcase now produces an Alter Procedure statement instead of dropping and creating the view. This preserves existing authorizations.
When selecting to display Keys, columns that are not PK but are parents in a Relationship (AK, Unique Index) are now displayed.
When a column is added to a table and a View is defined on the table as "Select All", the new column now appears in the "Column Editor" list of columns.
The script produced to drop from the database Stored Procedures not found in the model has been corrected. It used to be empty.
When Tables were not selected in the Sync dialog, and "Check objects not found in the model" was checked, Tables, Stored Procedures, Functions and Views not in the model were not displayed.
When displaying hidden relationships, the layout algorithm is executed if Automatic Layout is selected.
In the Sync dialog the size of the Action Column has been increased so that its content is fully displayed.
Support for SQL Server 2008 has been added to Xcase Pro
Support for PostgreSQL has been added to Xcase Pro
Xcase can automatically layout your diagrams using Orthogonal or Hierarchical layouts. You can also set the display to be automatically arranged when you modify its contents or add new objects.
The interface allowing to define or modify Views has been completely revised. A new combined dialog allows you to view and edit all view attributes easily. The generated SQL statement is now visualized and updated dynamically as attributes change.
You can now better control the naming conventions of objects created in the model. Object names can be set using templates which can use all attributes in the model.
When reverse engineering, you can now select specific Entities, Views, Functions and Stored Procedures.
The currently open displays appear as Tabs at the top of the display window.
The appearance of the reports produced by Xcase has been greatly enhanced.
Right clicking an Entity in a Diagram now allows selecting "Add Related", which adds all parents and children of the selected entity to the diagram.
You can now send a model archive via e-mail.
Archived model (xcs files) are now associated with xcase.exe, so double clicking an xcs file opens the model.
All graphic modifications to a display can be undone or redone.
The elements of a View are now visible in the Tree.
A new dialog allows you to rename a model.
When you marquee select multiple objects, you can now right click one of them to modify a property (such as color) and choose to apply it to all selected objects or only the current one.
File > Print > One Page Display now includes options to print the Current Display, All Open Displays of the Current Model, or All Displays of the Current Model.
The bottom pan of a browser can now display Multiple Tabs (each displaying a single attribute) or a Multiple Attribute Form. This can be configured in the General Tab of the Settings dialog. The layout of the Multiple Attribute Form can be modified using the Form Design mode, allowing moving, resizing and customizing attributes.
When printing diagrams to PDF with Adobe PDF printer, incorrect PDFs may be generated. Using CutePDF Writer resolves this. You can now disable gradients when printing via the General Tab of the Settings dialog.
In the Sync dialog, when selecting embedded diagrams, the entities included in embedded diagrams are now also selected.
When the bottom pan of a browser displays multiple tabs, the color of each tab now indicates whether it contains content.
When creating a new model, the Model Settings dialog allows defining the Referential Integrity implementation. This sets the default Referential Integrity behavior at model level and can be overridden at relation level through the Referential Integrity dialog.
Including: Schemas, Partitions, XML collections, XML Indexes, Index Included Columns, Description Extended Property, CLR Objects and more.
Including: Views, Stored Procedures, Functions and Triggers.
The workspace has been completely redesigned to be consistent with the Windows XP look.
The toolbar has been redesigned in XP style and includes tool groups such as File, Edit, Database, Model, Display, Zoom, Adjust and Shapes.
The menus have been enhanced and reorganized into more logical units.
You can now select multiple discrepancies in the list and apply an action to all selected items at once.
All browsers and inspectors have been regrouped into multi-tab specific browsers so all settings relevant to a task can be done without navigating back and forth.
The Physical Data Browser has been redesigned. For each parent entity in the upper pane, all child entities now appear in a tabbed browser in the lower pane.
Clear and Show Messages have been regrouped into a single Message Log window accessible from the Window menu.
All dialogs have been redesigned in XP style and some have been split for clearer grouping of actions and settings.
The Xcase Help System has been fully reworked using compiled HTML Help format, with more screenshots and clearer text.
Pressing F3 while typing an Entity, View or qualified column name in the Code Editor allows auto-complete selection from the Data Dictionary dialog.
This feature aligns selected entities horizontally or vertically and includes an “equal spacing” option.
The Dynamic Zoom Tool lets you change zoom level by clicking and dragging the mouse in the workspace.
This function fits the current diagram to the program window more efficiently than standard maximize or tile options.
This function resizes the entire display to fit the display window. If a marquee is active, it applies only to the marquee region.
The Hand Tool lets you grab and move the display easily to focus on specific areas.
Hotkeys allow common commands to be executed with a single key press.
This Display setting shows non-nullable fields in bold to make them stand out.
You can now create a new diagram based on the current one by right-clicking the workspace and selecting the corresponding option.
The Synchronize Database with Model dialog now includes a Setup button that opens the ODBC Data Source Administrator directly.
Model reports now include a Comments column. If an object’s descriptive name differs from its physical name, it is displayed alongside it.
The Display Settings dialog (from the View menu) allows easy modification of display settings. Defaults can now be set.
Right-clicking a relationship line now allows automatically straightening it instead of manually dragging it.