I’m new to Toad Data Modeler. I’m using version 3.4.14.6 to reverse engineer a MS SQL Server 2008 server with multiple databases.
I can’t seem to figure out how to reverse engineer the entire server with all it’s databases into one model (with the relationships across databases kept intact). If I don’t specify a database when I’m building the Data Link Connection String there are no tables available for reverse engineering. If I specify a database, I’m restricted to only reverse engineering that database.
I’d ideally just connect to the server and reverse engineer all databases in one go. Please let me know if I’m missing a step or if the functionality I’m looking for is just not available at the moment.
Unfortunately, it is not possible to RE entire server with all its databases at one time.
In TDM you have to connect to a particular database.
The only solution is to RE each database and then merge the reversed models (to the existing model or to a new model).