01-05-2015 08:03 AM - edited 03-17-2019 01:29 AM
Hi Guys,
I've done to transfer CDR data to another server (billing server) by using sftp. Now I would like to know how to import these files to SQL Server 2008.
Please advise and appreciate your help.
Regards,
Tan
01-06-2015 12:12 AM
CDRs are just CSVs, so you need to go ask in a SQL Server forum on how to do this.
NOTE: The CDR format tends to gain fields between CUCM versions (even minor versions) so you should make sure your import process can handle extra/unexpected fields.
GTG
01-06-2015 02:18 AM
CDR is flat file and no extension, do you know what's best third party software for this?
regards,
Tan
01-13-2015 07:12 AM
Variphy has a great CDR solution. There are others out there as well but that was my preferred vendor after looking at other solutions.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide