Toad World® Forums

Reverse Engineering MS SQL Server 2008 Question


#1

Hi,

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.

Thanks,

-Dipin


#2

Hello Dipin,

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).

Please see:
http://modeling.inside.quest.com/entry.jspa?externalID=3028&categoryID=158
http://modeling.inside.quest.com/entry.jspa?externalID=3055&categoryID=158

http://modeling.inside.quest.com/entry.jspa?externalID=3039&categoryID=159

If you have any questions, please write me back. Thanks.

Regards,

Vladka


#3

Vladka,

Thanks for the information.

Do you know if there are plans to support reverse engineering an entire server?

Thanks,

-Dipin


#4

Hello Dipin,

It’s not planned for now. I’m sorry.

Regards,

Vladka