Moving DW-tables to new database
How can I move the DW-tables to a new database? Or is it possible to recreate the DW and the re-populate it from CCM and JTS databases?
Please advice.
Best regards,
/Fredrik
|
Accepted answer
You can drop the DW tables from the CCM DB, and recreate the DW in a seperate database. Once the tables are created correctly, you can run your ETL (data collection jobs) which will extract all the data from CCM and your other applications and store it in the DW.
Fredrik Jägare Lilja selected this answer as the correct answer
|
One other answer
Hello Fredrik,
just an additional thing you should be aware of, is that by dropping and recreating/repopulating the data warehouse you are going to lose the metrics and trending data from the past. They will be available in the new data warehouse only from the date of the first data collection job, onwards. Best Regards Francesco |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.