cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
959
Views
3
Helpful
4
Replies

Export or Convert CAR 4.0 Database

pavlosd
Level 2
Level 2

Hi All,

We currently have CAR 4.0 implemented with local database. Since the number of users is constantly growing, we were wondering if there is any ?easy? way to migrate into an SQL database solution (Oracle or MySQL)

a) Is there any other tool for converting it into SQL (Oracle)?

b) Is there any tool for exporting the CAR 4.0 local database into an XML or Comma delimited format?

Regards.

4 Replies 4

bbaley
Level 3
Level 3

The CAR database stores CDRs and CMRs that serve as the basic information. Because this involves modifying the database, use the SQL user CiscoCCMCDR and SQL Manager for MySQL works with any MySQL versions from 3.23 to 5.06

If you want to know more please click following URLs:

http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a0080100566.shtml

What you are descriping is for Call manager.... What about Cisco Access Registrar 4.0?

The local database has 3 files....

/cisco-ar/data/db/

mcddb.d01, mcddb.d02, mcddb.d03

Not sure if this helps:

/cisco-ar/usrbin/mcdadmin: [-c] -d {dbdirname|DEFAULT} -[r|R] DBPATH -p

DBPATH -i importfile -e exportfile [-z C=N]

where:

-c attempts to create database

-o when creating, overwrite pre-existing database

-T recopy database templates when creating database

-t DIR specifies directory from which to get database templates

-d DBNAME specifies the database name, or "DEFAULT"

-N NAME specifies username (will prompt if not given)

-P PASSWORD specifies password (will prompt if not given)

-s supplies default name and password

-i IMPORTFILE specifies file to import from. ("-" for stdin)

-l don't hold exclusive lock while importing (slower, but

friendly)

-e EXPORTFILE specifies file to export to. ("-" for stdout)

-f EXPORTFILE exports diffable file (not importable) to export

to. ("-" for stdout)

-a DBAREA specifies the "area" of the database to use

("config", "state", "altconfig", or "altstate",

defaults to "config"

-p DBPATH specifies (on export only) what to export

-r DBPATH specifies something to remove ("trims" table)

-R DBPATH removes recursively! (or "clobbers" table)

The use of DBPATH in -p, -r, and -R is as follows: either

it is an absolute pathname, starting with '/', in which

case it refers to that part of the MCD tree, or it is a

"server zone name" tuple, starting with ':'. The names

after

the ':' are whitespace separated, and the name or zone and

name may be left unspecified. example: -p "myserv azone

foo"

-G GENERATION specifies generation number for RR table export

-H says full table generational history should be dumped

-k kill the lockmgr, do nothing else

-z CCC=N sets debugging classes CCC to level N

-v, -V prints version information

OK, seems helpful enough.....

Do you have any syntax example? I do not want to mess up with my existing database .... :-(

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: