You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

 

ApexSQL Model release notes

Release:

2019.01.0162

Date:

December 06, 2019

Enhancements:

  • SQL Server 2019 support
  • Constraint customization
  • Create a model from a snapshot
  • Export selected part of a diagram as image
  • Generate SQL script from a model
  • Index customization is added in the Edit table dialog
  • Import only selected objects from database to model
  • Profiles for table customization
  • Show/hide tables on diagrams

Fixes:

  • "Could not load file or assembly" error is encountered when right mouse button is pressed on the File name template text box in the Output tab from the Options window
  • "Cannot open database AdventureWorks2012 requested by the login. The login failed" error is encountered when creating a model for an offline database
  • The application cannot be integrated into any SQL Server Management Studio or Visual Studio version through the silent installation
  • All SQL Server Management Studio and Visual Studio versions are checked by default in the integration step of the application installation wizard
  • The uninstall confirmation message box appears is shown when the /verysilent and /suppressmsgboxes switches are used
  • The application cannot be integrated into any SQL Server Management Studio or Visual Studio version when the silent installation is initiated through CLI switches
  • "Table wasn't found" error is encountered when deleting the table from the Object browser and then using the Undo button to bring back the table and try to edit the same table
  • The Undo function does not work after deleting Schema objects from the Object browser
  • Right-click context menu will not work on any object if object is browsed within the group
  • When a relation between tables is unchecked in the Object browser panel nothing happens
  • The table is shown in the Object browser panel, although it was not created in the model diagram
  • Multiple groups with the same name can be created

Changes:

  • The application now only loads schemas and tables when using the Create model from a database feature, instead of all objects from a loaded database

Known issues:

  • "Azure Active Directory MFA Authentication is not supported" error is encountered when using execute now for create database, compare to a database or update database options with the Active Directory – Universal with MFA support authentication

Release:

2018.04.0113

Date:

June 21, 2019

Changes:


Release:

2018.04.0104

Date:

May 22, 2019

Fixes:

  • "Index was outside the bounds of the array" error is encountered when the saved project file is opened with a double-click on it
  • "Requested value 'Compact orthogonal' was not found" error is encountered when the model saved in the compact orthogonal layout is opened
  • "Requested value 'Direct orthogonal' was not found" error is encountered when the model saved in the direct orthogonal layout is opened
  • "Object reference not set to an instance of an object" error is encountered when the OK button is clicked in the Connection options dialog after changinig value for timeout options
  • Data type settings cannot be changed under the Data type column in the Add table window
  • The add-in doesn't integrate with SQL Server Management Studio 18 GA version

Release:

2018.03.0090

Date:

February 12, 2019

Fixes:

  • Data type column in the Add table window must be used only with predefined data types

Changes:

  • ApexSQL parent menu of the add-in is now located under the Extensions main menu in Visual Studio 2019

Release:

2018.02.0088

Date:

December 27, 2018

Enhancements:

  • SQL Server 2019 CTP 2.0 support
  • SQL Server Management Studio integration support
  • Visual Studio integration support
  • Azure SQL Database– Managed instance support
  • Active Directory support for:
  • New error handling and send logs functionality
  • Improved application installer with a dark theme
  • New application icon
  • Create database from model:
    • Create script
    • Create database
  • Update existing database:
    • Create synchronization script
    • Update database
  • Update existing database in one click
  • Create DDL script from existing model
  • Compare model to database via ApexSQL Diff
  • Compare model to snapshot via ApexSQL Diff
  • Document model via ApexSQL Doc
  • Add notes on database diagram
  • Model categories to group models visually
  • Customizable output script header and footer are added under the Output tab in the Model options window
  • Customizable arguments for updating database via ApexSQL Diff are added under the Output tab in the Model options window
  • Schema customization is added in the Table design window
  • Table style options are added in the Options window
  • Printer friendly option added
  • Convert colored group to text option is added in Print window
  • Added status bar information:
    • Groups number
    • Server name
    • Project version
    • Unsaved changes indicator
  • Project level options:
    • Associated database
    • Project version
    • Application output options on project level
  • Improved table design/display options:
    • Background color is following themes
    • Syntax highlighting option for data types and keys is added
    • Icons for keys are added
    • PK separator option is added
    • Options for customizing header are added
    • Options for customizing displayed columns are added
    • Option for customizing nullable column name
  • Improved design of groups on diagram with styles
  • Improved print options to be more user friendly
  • Search feature is improved
  • Added schemas in search feature
  • Added groups in search feature
  • Option for creating backup of a database before update database is added under the Output tab in the Options window
  • Option for creating rollback script before update database is added under the Output tab in the Options window
  • Option for creating snapshot before update database is added under the Output tab in the Options window

Fixes:

  • Print preview is not refreshed when an option is changed in the Print options window
  • Image of an empty diagram can be exported
  • Snapshot of an empty diagram can be exported
  • ApexSQL Diff not installed message is shown when update/create process is started instead before starting it
  • There is no information about ApexSQL Diff trial period expired when forward engineering action is initiated
  • Models in dark theme aren’t printer friendly

Changes:

  • ApexSQL Model is now free and has no editions
  • The application now requires Microsoft .NET framework 4.7.2
  • Reverse engineer feature is now Create model feature
  • Forward engineering feature is separated into:
    • Create database feature
    • Update database feature
  • Custom task feature has been removed
  • Excessive icons reduced from table displays
  • Print preview is improved to follow application themes
  • Regions are removed and will be improved for ApexSQL Model 2019

Known issues:

  • Backups are created in the same location, even when the location is changed, until the application is restarted
  • ApexSQL Model 2018 R2 isn’t backward compatible with R1. See this article for information on upgrading models

Release:

2018.01.0050

Date:

May 10, 2018

Features:


© 2019 Quest Software Inc. ALL RIGHTS RESERVED.   |   1-800-306-9329   |   sales@apexsql.com   |   GDPR   |   Terms of Use   |   Privacy