As a new user im getting a little frustrated in that i manage 7 DB servers, from Dev, test, CI, Preprod and prod to name a few. Each server has ~ 10 databases on it.
My question is:
Is there a way to quickly add all the databases i need to manage from one server, or, do i need to go through all the different servers adding all the different databases one by one?
In SQL server management studio you register the server and then get access to all the databses on that server. so i only need to set up 7 connections rather than 7x10 connections. is it possible to do the same with datagrip?
Is is turning into a make or break feature for me, any tips from anyone in a similar situation?