ApexSQL Model 2018 – Screenshot tour

The main window of ApexSQL Model, showing the Home tab action buttons. This window is shown when the application is started:

Actions tab of the main application window of ApexSQL Model. Add, Engineer and External action section with its buttons are located here:

View tab of the main application window of ApexSQL Model. Display and Show panels sections with its buttons are located here:

Click on the Create model button, the Create model dialog with SQL Server connection options is shown where the desired database needs to be selected for reverse engineering:

When the selected database is connected and loaded, data model diagram will be shown in the main window:

Data model diagram look can be changed using the Layout and Edge routing options in the View tab. This data model diagram is shown in Hierarchical layout mode:

Select a few objects and click the Group option from the right-click context menu and, they will be grouped together like in the picture below:

Click on the Create database button from the main ribbon bar, the Create database window is shown where database script can be opened or executed for the existing model:

When the SQL Server connection parameters and the new database name are specified, click the Open script button and the SQL script for creating the new database will be opened in the integrated script editor of ApexSQL Model. Script can be viewed, updated and executed to create the new database:

Click on the Compare to database button, the current model will be converted to a snapshot and it will be compared with a selected database using ApexSQL Diff:

To create a new model, click on the Table button in the Actions tab. Add table window will be opened, where the columns of the created table need to be specified and the table schema selected:

Click on the Relationship button from the Action tab, then click and drag between tables for which relationship needs to be formed:

Double-click on the relationship, and the Edit relationship window will be opened. Optional relationship details can be changed such as relationship type, cardinality and optional table:

Click on the Schema button in the Actions tab to add a new schema and specify its name:

Click on the Search button in the Home tab, to search for tables and relationships on the existing model:

Click on the Print button in the Home tab, to print existing model. In the Printer tab, the default printer can be changed. Also, Printer friendly and Display group name options can be used. The number of copies can also be changed:

In the Layout, Scaling and other Print options can be changed on the print preview.

In the Page tab, Orientation, Margins and Size options can be changed:

In the Additional tab, various text options including watermark can be changed:

Click on the Image button in the Home tab to export a model into an image. Model can be exported into JPEG, PNG and Bitmap image files:

Click on the Snapshot button in the Home tab to export a model into snapshot which can be used later by other ApexSQL applications:

Click on the Options button in the Home tab to change General, Table style, Output and Shortcuts options. In the General tab, Auto save, Theme, Text and Version number options can be changed:

In the Table style tab, Rows, Syntax highlighting, Keys, Table header and Grouping style options can be changed:

In the Output tab, File locations, Output action and editor, ApexSQL Diff project, Optional output elements and Header and footer options can be changed:

In the Shortcuts tab, application shortcuts can be pre-defined:

 

May 25, 2018