Skip to Content
0

Overview of SSM Database Transporter

Nov 24, 2016 at 07:29 AM

91

avatar image

Hello,

I am looking for an overview of the different procedures / functions that SSM Database Transport provides. I currently see 6 different Import/Export options on the screen and it is not clear what functions these provide. I am old school SSM so am aware of PAS modelling and coding, as well as Metadata modelling in SQL tables (including E&A data in same but not in PAS). Can someone direct me to what these 6 different options do, as for example, there is only mention of "database" and "data" - is that PAS data, PAS database, SQL model (incl 150 tables) database, SQL metadata data? I am looking for a consistent approach to modelling in DEV - both MetaData and PAS, and migrating that upwards to QA and PRD. And then making model changes in DEV to pass the changes to QA and then PRD (both meta and PAS) without affecting PAS data or E&A data in SQL tables. If Database Transporter can assist here then I need to know what they do !! Is there an overview or document that provides this?

Kind Regards,

Endre

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Graham Cunningham
Nov 24, 2016 at 10:14 PM
1

Hello Endre,

Check out the Interactive Publisher and Application Components Administrator’s Guide located at

http://help.sap.com/bosm.

The transporter imports and exports the application component data and model connection data from the NW database. You would still need to copy the PAS model over to the target system if changes have been made to the model.

Regards,
Graham

Share
10 |10000 characters needed characters left characters exceeded
Endre Sparkes Nov 29, 2016 at 05:45 AM
0

Thanks Graham, documentation seems to be there albeit a bit jumbled up...

What would the procedure be for the following :

Assuming I have both Component model and PAS model in both DEV and QA as identical. DEV = QA.

I now add multiple contexts and library items in DEV. I create further measures in PAS etc also in same DEV. i.e. I perform development work as per standard / usual.

I now wish to "transport" only selective contexts, and not all contexts as some of them are still being developed and don't yet need UAT (incl selective Library items) of the Component model from DEV to QA. Same for Initiatives. And not all my created PAS measures need to be move to QA either. I can write a PAS proc to add the new measures, dims etc, to go into QA, but what about the selective contexts? Is that possible or do I have to export and import the full component model and delete the additionals I don't require manually from QA?

Kind Regards,

Endre

Share
10 |10000 characters needed characters left characters exceeded