ApexSQL Model 2018 R2 has been released
About ApexSQL Model: ApexSQL Model creates database model diagrams and can be used to synchronize changes with existing databases. ApexSQL Model is used for database reverse and forward engineering in synergy with ApexSQL Diff and allows for data model diagrams appearance customization, printing and exporting into several graphical image formats.
For more information, visit the ApexSQL Model product page
About this release:
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
Improved quality:
- 6 bugs and known issues fixed
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
See also:
Release notes
Download
December 27, 2018
