Query copy from Production to Development?.

[Former Member]

Hi,

Did anyone find a solution to copy queries from production to development (not manually or not using transports)?.What for BC sets are used?.Share your ideas please.Thanks.

Ravi.

[Former Member]

Hi GFV,

Did you try with XML?.I thought XML was not working for queries.Please let me know how did you do it with XML.Thank you.

Ravi.

[GFV]

In RSA1 go to Transport Connection. Ther you find XML icons, that should be used to exchange metadata between different sys. We did try during a course, but it's quite slow and it's better not to put too many Objects in one XML Export ...

See the following link for more details ...

http://help.sap.com/saphelp_bw30b/helpdata/en/ad/6b023b6069d22ee10000000a11402f/frameset.htm

Sorry but I don't remember other docs about this issue, but I'm sure there are!

Hope it helps

GFV

[GFV]

We considered the option to use XML, but keep in mind it requires BW 3.x ... On anotther inst. we did use trasports as well, with no problem.

Hope it helps

GFV

[former_member93896]

Hello,

just one remark. Transporting from Production to Development is definitely not "Best Practice". For exceptions this is OK, but I can't recommend to do this on a regular basis. Because in the end you will turn your production system into a development box and create potential circular references:

DEV -> QA -> PROD -> DEV

Regards,

Marc

SAP NetWeaver RIG, US BI

[GFV]

Yes, I know and I was "disguted" at the idea to do that ... but a lot of reasons have required PROD -> DEV to ensure consitency ...

Best Regards

GFV