Toad World® Forums

Able to get multiple dbs into same drawing?


#1

I am using the SQL ODBC connection for set up of a RE.

I can extract a single db to a .dm2 file. Now i want to put a second and third db on the same .dm2 file. Is that possible?

My current system has 9 dbs for a very narrow base of data. Users has all the customer data, and Orders has all the Order HeaderData. Offering has all the order details , Discounts has all the discount schemes.

I wanted to model the interaction between the dbs so I could get working on a DW model.

Is this possible, or is it because the postback of changes to a db would get all confused whit multiple dbs?

TIA

__Stephen


#2

Please see:
http://modeling.inside.quest.com/thread.jspa?threadID=4464&tstart=0

Vladka