0

I am using SSMS 2017 and SQL server 2017, I have many companies and each company has many databases.

For example. I have five companies:

Company1, Company2, Company3, Company4, Company5

Every company has many databases:

Employees_DB, Products_DB, Customers_DB (we are talking about 15 database)

Each of the previous databases has many tables.

How can I create a folder for each company, so it has all its own databases?

To be the result :

Company1 folder : Employees_DB, Products_DB, Customers_DB

Company2 folder : Employees_DB, Products_DB, Customers_DB

Company3 folder : Employees_DB, Products_DB, Customers_DB

Company4 folder : Employees_DB, Products_DB, Customers_DB

Company5 folder : Employees_DB, Products_DB, Customers_DB

closed as unclear what you're asking by Andriy M, mustaccio, Colin 't Hart, RDFozz, Erik Darling Aug 8 '18 at 18:56

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    What do you mean by project? It looks like in this case an illustration would help to understand what exactly you are talking about. Specifically, I would appreciate an illustration showing where you want the folders to be, thank you. – Andriy M Aug 8 '18 at 7:29
1

You can create groups in the server registration view... not sure how that fits with your use of the word ‘project’, so whether it’s suitable for you - you need to decide.

Create or Edit a Server Group (SQL Server Management Studio)

  • Thank you for your time, this is a good solution when I want to give each company its own server, but I have only one server, and I want to put a folder inside for each company, I want to dedicate many folders in the server with the names of the companies – Husam Ebish Aug 7 '18 at 19:31
  • 1
    There's nothing like this in SSMS, I'm afraid. There's Server Registration as suggested, but that is at the server level. And there's "Solution and Projects" in SSMS, but that is just a "grouping" of sql files. And differentiating logins doesn't really help either since all logins sees all databases (unless you can make the login the owner of the database and DENY VIEW ANY DATABASE). Having categorization/grouping at various level would be a cool feature in SSMS - considering request this at feedback.azure.com/forums/908035-sql-server. – Tibor Karaszi Aug 8 '18 at 7:38

Not the answer you're looking for? Browse other questions tagged or ask your own question.