Thanks for the reply.
I made a mistake by stating my request in the BETA group. I downloaded the standard tool if that means any difference.
At this time I am NOT writing back to the db(s). In the future I imagine that I will.
Currently I just want to map the small dbs into a single document and add the necessary links between the dbs that exist.
I do want to merge the separate systems into a centralized DW, and that is what my initial task is.
We are a job shop where a single order can be directed to 1-N recipients. That same order can have a lifespan as well as be updated over time. Tracking those changes is not important at this time :), because it’s the clients property not ours. We have to keep every version separate but that is already done.
I have a db for Clients based around a marketing POV. I have an Ordering db that is focused on orders placed with our breakdown of an order. I have an Addressing system as well as a Shipping system that maintain who gets what and how it got there.
You can see that I am hopping dbs for access to tables all the time. I want to combine all these dbs into a single model which will hopefully keep me from making a wrong decision in the beginning about how I am going to set up the DW.