Overview

In this document we explain how to create new DBs in new Projects and the association with the 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 “Database” icon at the top header.

On Submenu, selects “Instances” and then click “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 DB 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, Wayfast user can select the “Production” environment or any other instance.

On Submenu, click again “Database” section.

...

Wayfast displays all the Databases in a grid view, there are the related DBs to our Project at this point. If Wayfast user wants, there’s a chance to associate a previously created DB using the “Attach DB” button to the Project

In this example, we are going to create a new DB from the scratch. Click “Create” button

...

A popup is displayed with the “Instance” dropdown field. You can choose by selecting between all the instances that we set it up in the previous step.

Click “Save” button

...

Now we have the DB 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 “Refresh” option

...

DB object is available with all the default folders associated. 

NOTE: Wayfast Admin users can create the DB 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 document, 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 DB is used in each environment that we are going to use for development.