cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
486
Views
0
Helpful
2
Replies

Historical Reporting Database

Tony Knight
Level 1
Level 1

Hi

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?

Thanks

2 Replies 2

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

david

Nathan Luk
Level 1
Level 1

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.

Cheers,

Nathan

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: