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 headermenu.
...
On Submenu, selects “Instances”.
...
Then click on “Associate Instances” button to setup the new DEV Environment for the Application DBdatabase.
...
Wayfast automatically shows the different instances (Environments) that can be associated to the DB 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.
Recap
In this lesson, we defined the Instances in the Project to establish new relations with our DB database is used in each environment that we are going to use for development.