Pinned topic Merging Two Datawarehouses
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
We have two ITM data warehouses (one that was created specifically for the TSM Monitoring). I'd like to MERGE the two by taking the data from the TSM Monitoring Warehous to our main Warehouse. Do I just export the tables created by ITMUSER and import them into the other database? Do I need to do anything with the Indexes?
Updated on 2013-03-22T02:35:44Z at 2013-03-22T02:35:44Z by SystemAdmin
SystemAdmin 110000D4XK6056 Posts
Re: Merging Two Datawarehouses2013-03-22T02:35:44ZThis is the accepted answer. This is the accepted answer.The best approach is to use the TDW schema tool to create the SQL scripts that can be run to create the tables in your new Warehouse Database:
This will create everything needed(indexes, etc.) so that then you can import the data from your other database into the new tables.