How to setup the Database in Wayfast?
- Sergio Rodriguez
- Matias
Overview
In this lesson we will explain how to associate multiple instances to our Projects in Wayfast.
We can think these instances as different work environments. This will allow us to handle requests to work with the data in any of the databases managed by that instance.
What’s an instance? We can read more about what's an instance in the following article.
How to associate a new Instance from Wayfast?
On Wayfast, make sure that the Project is created and at least, a requirement is in “Active” status.
Click on “Database” icon at the top menu. On Submenu, selects “Instances”.
Then click on “Associate Instances” button to setup the new DEV Environment for the Application database.
Wayfast automatically shows the different instances (Environments) that can be associated to the database that we are going to create in our next lesson. Click on “Submit” button
NOTE: This selection should be repeated each time that you want to link different instances.
At this point, we have the new instance associated to our Project in the “Instance” dashboard screen.
How to create a new Database from Wayfast?
Now that we associate different instances, let’s create a new database.
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 that we will learn in other lesson.
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.
Complete the required fields and click on “Submit” button
Now we have the database object associated to the Project and we can continue defining the Requirements.
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 developers can create the databases 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 Instances in the Project to establish new relations with our database is used in each environment that we are going to use for development.