Overview
In this document lesson we will explain how to associate multiple instances to our Projects in Wayfast.
Through the instances, we are going to access the DBs and, therefore, the objects that compose it.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.
...
Wayfast automatically shows the different instances (Environments) that can be associated to the DB that we are going to create in our next steplesson. Click “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 documentlesson, we defined the Instances in the Project to establish new relations will allow us to define which with our DB is used in each environment that we are going to use for development.