The main window of ApexSQL Model, showing the Home tab action buttons. This window is shown when the application is started and it’s used the most.
View tab of the main application window of ApexSQL Model. Display, Grouping and Panel action buttons are located here.
Resources tab of the main application window of ApexSQL Model. Showing common action buttons of ApexSQL applications.
When clicking the Reverse engineering button, the SQL Server connection window is shown where the desired database needs to be selected for reverse engineering.
When the selected database is connected, it will be shown as a data model diagram in the main window. Each new loaded database model diagram will be shown in Hierarchical layout by default:
Data model diagram look can be changed using the Layout and Edge routing buttons in the View tab. This data model diagram is shown in Orthogonal layout mode:
When selecting a few objects and clicking the Group option, they will be grouped together like shown in the picture below:
Group color can be customized using a wide palette of colors for providing an appealing look:
When clicking the Enter group button, only the objects inside the group will be shown as if the group itself was entered. To exit the group and show the rest of the diagram, the Exit group button needs to be clicked:
When clicking the Forward engineering button from the main ribbon bar, the Forward engineering window is shown one of the two available options needs to be chosen:
- Create DDL script
- Create Sync script
Selecting the DDL script option will be used to generate a CREATE script for a new database using the existing model.
When the SQL Server connection parameters and the new database name are specified, clicking the OK button generates the SQL script for creating the new database and opens the completed script in the script editor of ApexSQL Model that can be viewed, updated and executed to create the new database.
The Sync script option from the Forward engineer window is used for comparing the loaded model with a target database and automatically generating a synchronization script for altering or updating the targeted database:
Once the SQL connection details and the target database has been specified, clicking the OK button initiates the creation of the sync script and once its completed it will also be shown in the script editor of ApexSQL Model:
When creating a new model, clicking the Table button opens the Add table window where the columns of the created table need to be specified and the table schema selected:
To add a relationship between tables, click the Relationship button from the main ribbon bar, then click and drag between tables that need to form a relationship:
When double clicking the relationship, the design relationship window is shown with optional relationship details that can be changed such as relationship type, cardinality and optional table:
To create a new schema, click the Schema button on the main ribbon bar and specify the schema name:
The Custom tasks selection window is used for creating executable custom actions using one of three predefined templates or a completely custom template:
A created custom task with its batch script shown in the custom task editor:
Saved custom tasks can be later used from the dropdown menu under the Custom tasks button in the Home ribbon bar:
The Search window is used for general object search when clicking the Search button from the main ribbon bar:
The Printer tab of the Print options window:
The Layout tab of the Print options window with scaling and other print options showing the print preview:
The Page tab of the Print options window with orientation and other page options showing the print preview:
The Custom text tab of the Print options window with various text options including the watermark:
Models can be exported into image files by clicking the Image button in the main ribbon bar:
Models can also be exported as database schema snapshots, by clicking the Snapshot button. These snapshots can be later used by other ApexSQL application like ApexSQL Diff, ApexSQL Script and ApexSQL Build:
The General tab of the Options window, showing general options:
The Shortcuts tab of the Options window with predefined application shortcuts:
The Defaults window is used for setting up default options for the Print and Options windows:
May 25, 2018