I’m new to Toad Data Modeler. I’m using version 188.8.131.52 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).
If you have any questions, please write me back. Thanks.
Thanks for the information.
Do you know if there are plans to support reverse engineering an entire server?
It’s not planned for now. I’m sorry.