Overview
In this lesson we will explain how to create new databases at new Projects and the association between different instances depending on the environment that Wayfast users are going to develop the application.
How to create a new Database from Wayfast?
On Wayfast, make sure that the Project is created and you are logged in.
Click on “Database” icon at the top menu.
On Submenu, selects “Instances” and then click on “Associating Instances” to setup the new DEV Environment for the Application DB.
Wayfast automatically shows the different instances (Environments) that can be associated to the database that we are going to create in next step. This selection should be repeated each time that you want to link instances.
In the example, the dropdown is showing the “Development” environment. Depending on the Project, we can select the “Production” environment or any other instance.
On Submenu, click again on “Database” section.
Wayfast displays all the databases in a grid view, there are the related databases to our Project at this point. In case we have existent databases, there’s a chance to associate them by using the “Attach DB” button.
In this example, we are going to create a new database from the scratch. Click on “Create” button
A popup is displayed with the “Instance” dropdown field. We can choose by selecting between all the instances that we set it up in the previous step.
Click on “Save” button
Now we have the database object associated to the Project and we can continue defining the /wiki/spaces/~664035844/pages/1746600010.
How to verify that Database is generated in SQL Server Management Studio?
Open the SQL Server and connect to the “Instance” that we associate in the newly DB created.
Right-Click over the “Database” folder and click on “Refresh” option
New database object is available with all the default folders associated.
Wayfast Admin users can create the database from the SQL Server Management Studio without login to Wayfast and then use the “Attach DB” button to associate the new object into the Project.
Recap
In this lesson, we defined the structure by associating the Project with a Database. Also we learnt how to create a new database in the Project and associate the Instances to the created object. This relation will allow us to define which database is used in each environment that we are going to use in development.