Hi,
I'm currently working on automatic creation of SLAs so I've been looking into this some. I'm at home now so can't have look at the queries I have, but as it all pretty much happens in the DB, all you need to do is recreate the definitions in your new database.
I wouldn't go as far as saying you can export / import, but pretty close. The good news is (in some cases), that the qos calculations do not make use of the device id, cs id, device metric mess. I'd say what you have to do includes something like this (disclaimer: off the top of my head, so might need checking ):
- create your qos calculation and sla calculation profiles if you've defined custom ones.
- take a look at S_SLA_DEFINITION table. You'll need to insert stuff here in the new DB. The columns should be pretty self explanatory
- take a loo kat S_SLO_DEFINITION. You'll need to insert here and link to proper SLA ids that you've just created. It will require some logic, as your SLA IDs probably wont match the ones that you had in your previous DB. I imagine this step will otherwise be pretty simple, depending on you've set up your SLAs
- take a look at S_QOS_CONTRAINTS. These you'll need to link to the SLO id's you created by inserting into the S_SLO_DEFINITION table. Here you'll need to use qos-name, source and target from your previous DB and also the thresholds etc, operating periods etc.
Having taken care of that, you'll have a bunch of SLAs. After that you'll probably want to group them and link them to proper accounts
To link to accounts, have a look at CM_ACCOUNT_SLA. You'll need accoutn id and SLA ID
To create groups, take a look at S_GROUP_SLA and S_GROUP_DEFINITION.
That might be all, then again it might not
-jon