I am trying to copy the UCCX 8.5 Informix database to Microsoft SQL, so we can use MSSQL as the source database for our reports. This way we will not stress our UCCX database too much, except for when we run the batch copy every night.
To copy all tables to SQL I am trying to use SQL Server 2008's SQL Server Integration Services (SSIS), the Import and Export Wizard (DTSWizard.exe). I open the Informix database as a local ODBC, using the .Net Framework Data Provider for Odbc to read all data. I then use the SQL Native Client to write the data into MSSQL.
When I try to do this, I run into a couple of issues:
1) Some field types in Informix are unknown to SQL. I have to manually reassign them. Most of them are datetime fields, so I guess I should just mark them as datetime type in SQL?
2) When I finished assigning the datetime type to the unknown fields and try to run the migration, I receive the following error. I don't have a clue how to get around this:
Does anyone have any experience with what I'm trying to do? I know Cisco recommends using a separate SQL server for reporting, but I haven't found any documents describing how to do this. Can anyone help?
I am about to head down the same path and am doing research to get started. Same environment, UCCX 8.5 looking to get data into SQL Server. Had you found some good advice and implemented the process? Can you tell me anything about the nightly refresh that you may have in place?
...or are you still having the issue you originally reported? If so I will start down my path and reply back with any positive findings.
I'm not able to access my old voice mail messages all of a sudden. The recording says something like 'the message is currently not available'. This has never happened before in all the years I have been using this system. I have t...
If you have 2 ISR routers, one acting as Failover, do we need to have both the same number of SRST licenses on the 2 routers?
No. You will only need the SRST licenses on the primary router. Because this feature...
You have reached the Cisco Logistics Support Center.. To Check Status of your RMA, visit Product Returns & Replacements (RMA).
Need help? Contact us by Phone or Email.
Phone: 1800 553 2447 Option 4