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 is Instance in SQL?
An instance of the Database Engine is a copy of the sqlservr.exe executable that runs as an operating system service. Each instance manages several system databases and one or more user databases. Each computer can run multiple instances of the Database Engine. Applications connect to the instance in order to perform work in a database managed by the instance.
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 “Accept” button
NOTE: This selection should be repeated each time that you want to link 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?
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 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 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 Instances in the Project to establish new relations with our database is used in each environment that we are going to use for development.