Is there a way to show multiple databases in one model (.txp) for SQL server? I have a database server that has 8-10 databases on it and I'd like to just have one model that has everything in it versus having to have 8-10 models - 1 for each DB. In addition, we actually have probably a total of 20 DBs across all those servers (probably colder to 2500 tables across the entire system). We would actually be able to pull them ALL into one .txp.
There are two ways to get all databases of one database type in one .txp model file.
1. To RE individual databases one by one and then merge the models. Here there issues may appear if there are schemas or objects of the same names in different databases.
2. To RE all databases from one connection and divide them by schema. Once again, the issues may appear; in the case of the same schema names or objects in different databases.
In addition, it is also suggested that one may only want to group models in one Project.