Historical Reporting Database

Unanswered Question
Jun 13th, 2010


We have a thrid party developer requiring a copy of the HR database to start developing some custom historical reports.  What is the best way to get a copy of this db?


  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
david.macias Sun, 06/13/2010 - 17:56

Why don't you just use MS SQL Studio/Ent Manager to take an export of the HDS and AW dbs?


Nathan Luk Tue, 06/15/2010 - 17:44

Is it UCCX or UCCE you are using? If it's UCCX, the DB all the data is stored in is db_cra. If UCCE then you can do either push or pull for the data but if it's UCCX pushing data might be your best option using SQL Server DTS or SSIS packages as long as you have SQL Server on the box due to the limitation of UCCX SQL having to be in Windows Authentication only and not being able to join it to the domain.




This Discussion