• 1 reply
  • Latest Post - ‏2013-03-22T02:35:44Z by SystemAdmin
10 Posts

Pinned topic Merging Two Datawarehouses

‏2013-03-21T13:10:55Z |
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
    6056 Posts

    Re: Merging Two Datawarehouses

    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.