Historical Reporting Database

Unanswered Question
Jun 13th, 2010
User Badges:


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
User Badges:
  • Blue, 1500 points or more

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
User Badges:
  • Bronze, 100 points or more

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