Softpedia >Windows >Internet >Servers >Database Utils >ApexSQL Model >  Changelog

ApexSQL Model Changelog

What's new in ApexSQL Model 2020.01.0193

Sep 10, 2020
  • Enhancements:
  • Application telemetry now collects anonymous data on the use and performance of applications and application components
  • New ApexSQL Updater allows users to configure advanced updating settings of all installed ApexSQL products
  • Fixes:
  • "Note wasn't found" error is encountered when Edit button is clicked to edit previously deleted and retrieved note using the Undo option
  • Changes:
  • Error handling and send logs functionality has been modified

New in ApexSQL Model 2019.02.0169 (Mar 13, 2020)

  • Fixes:
  • "View database state permission denied in database "database name". The user does not have permissions to perform this action" error is encountered when trying to open a database without permissions to access the master database with the Active Directory authentication type
  • "Cannot use 'Authentication' with 'Integrated Security'" error is encountered when using the Execute now command for the create database process without permissions to access the master database with the Active Directory authentication type
  • "Invalid database selected. Select existing database" error is encountered when using the Execute now command for the update database process without permissions to access the master database with the Active Directory authentication type
  • Known issues:
  • "Azure Active Directory MFA Authentication is not supported" error is encountered when using the Execute now for the Create database, Compare to a database or Update database features with the Active Directory – Universal with MFA support authentication

New in ApexSQL Model 2019.01.0166 Patch (Jan 20, 2020)

  • Fixes:
  • "View database state permission denied in database "database name". The user does not have permissions to perform this action" error is encountered when trying to open a database without permissions to access the master database with the Active Directory authentication type
  • "Cannot use 'Authentication' with 'Integrated Security'" error is encountered when using the Execute now command for the create database process without permissions to access the master database with the Active Directory authentication type
  • "Invalid database selected. Select existing database" error is encountered when using the Execute now command for the update database process without permissions to access the master database with the Active Directory authentication type

New in ApexSQL Model 2019.1.162.0 (Dec 6, 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

New in ApexSQL Model 2018.04.0122 Patch (Aug 26, 2019)

  • Fixes:
  • 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

New in ApexSQL Model 2018.04.0113 (Jun 21, 2019)

  • Software Transaction Agreement is added as a new step in the installation wizard and updated in accordance with https://www.quest.com/legal/sta.aspx

New in ApexSQL Model 2018.04.0104 (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

New in ApexSQL Model 2018.03.0094 Patch (Mar 13, 2019)

  • Fixes:
  • Applying the layout changes takes over 5 minutes for SQL database with more than 200 SQL tables
  • Model diagram is not shown when the Edge routing view is changed
  • "Requested value 'Directed orthogonal' was not found" error is encountered when saved model in the direct orthogonal layout is opened
  • The data type in the Data type column in the Add table window cannot be edited

New in ApexSQL Model 2018.03.0090 (Feb 12, 2019)

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

New in ApexSQL Model 2018.02.0088 (Dec 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:
  • Password authentication
  • Integrated authentication
  • Universal with MFA support authentication
  • 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

New in ApexSQL Model 2018.01.0058 Patch (Jul 11, 2018)

  • Enhancements:
  • Clone option has been added to the custom tasks window
  • Column Description has been added to the custom tasks window
  • Three built-in custom tasks have been added:
  • Compare with database
  • Compare with model
  • Document model
  • Fixes:
  • "Could not load file or assembly 'ApexSQL.Common.GrammarParser'" error is encountered when the Save as button is clicked in the custom task window
  • Changes:
  • Templates from the custom tasks window are now moved to the new window which is being opened on the Add button from the custom tasks window
  • Fixes:
  • Items in the object browser are not highlighted when selected
  • It's not possible to execute created DDL and Sync scripts directly from the application

New in ApexSQL Model 2018.01.0057 Patch (Jun 5, 2018)

  • Fixes:
  • Items in the object browser are not highlighted when selected
  • It's not possible to execute created DDL and Sync scripts directly from the application