This topic has been locked.
1 reply Latest Post - 2013-03-22T02:35:44Z by SystemAdmin
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 PostsACCEPTED ANSWER
Re: Merging Two Datawarehouses2013-03-22T02:35:44Z in response to JGraulThe 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.