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.
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
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