In the Connect to SQL Server window, select the desired SQL Server and type of authentication, and click on the Connect button: To create the database from the generated SQL script, click on the Connect button in the Editor window. In the Editor window the database name can be changed before the SQL script is executed or saved: When the SQL script is generated, the first statement will be for the creation of a database, which by default is the DefaultDb database. Here the SQL script can be saved, so it can be sent to another team member or executed in SSMS: The Editor window with SQL script will open. Check tables that will be part of the SQL script and click the OK button: This action will open the Create script window where all created tables will be listed. When the tables are created in ApexSQL Model, the first step in the creation of SQL script process is to click on the Create script button under the Actions tab: More about how to create a table in ApexSQL Model can be found in the How to create or edit table using SQL data modeling tool article. This article will explain how to use the SQL script to create the database.Īn SQL script can be created for a newly created table in ApexSQL Model or for a table from an already existing database that has been previously loaded. This SQL database modeling tool also provides a possibility to create the SQL script for one or more database tables. In this article will be explained how to create a database using SQL script feature in the SQL database modeling toolĪpexSQL Model provides the possibility to create an SQL script that can easily be used in other tools, for example, in the SQL Server Management Studio ( SSMS), or can be saved locally as a backup or shared with other members in the team.

Script database sql