cancel
Showing results for 
Search instead for 
Did you mean: 

Copying Queries from 1 environment to another

Former Member
0 Kudos

Dear Experts,

Is the above possible ?

We have queries in our Production environment that we now need in our DEV & QA environments. Without the time and effort of recreating them all.

I'll explain that the reason they were done directly in PRD was simply because all the Claims data was migrated there and so the details required only existed there.

But now this data exists in our other environments and we now need these queries.

Your assistance as always is much appreciated.

Regards

Craig

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Sometimes you the ad-hoc queries or productions queries created in PROD is put into QA by system refersh.

Transports from Prod to Dev has some implications since you may have variables / queries of same name but different purposes and your objects in Dev become repairs typically.

For truly published queries and things such as variables, I usually prefer to recreate them in Dev and transport them up.

Former Member
0 Kudos

Hi Craig,

goto the transport connection, collect all queries in question and additionally all other necessary query elements (structures, variables, calculated and restricted keyfigures), assign all that to a transport request and import the request into your dev with some help of a basis person.

regards

Siggi

Former Member
0 Kudos

Siegfried,

Thanks very much for your answer. I wasn't aware transporting from PRD back to DEV was possible.

Are BASIS going to know how to do this, is there a different process for this form of transport that they need to be aware of?

Cheers

Craig

Former Member
0 Kudos

Hi Craig,

normally you don't have a transport way from prd to dev so there will be no automatic transport and the basis must take the cofiles (created when a request is released) and copy/move them to the import folder of the dev system. Additionally it might be necessary to change the object type of the included objects from 'copy' to 'original'.

Hope this helps!

regards

Siggi

PS: before creating a request, talk to your basis about possible other restrictions.

Former Member
0 Kudos

Siggi,

Thanks for this, I'll let you know if this works.

Former Member
0 Kudos

Siggi,

We have tried this but it doesn't appear to create these cofiles! Is this because it's creating Local transport?

Is there something else we need to do to get this process to work?

Thanks for your assistance.

Craig

Message was edited by: Craig Armstead

Former Member
0 Kudos

Hi Craig,

When a request is prompted in the prod and is released, the cofiles and are automatically created. If it is local transport, you cannot do it I believe.

Former Member
0 Kudos

To create cofiles and data files for a released transport from a QA or a PRD system, I would do the following:

- Create a new transport request of type "Transport of Copies" from SE09/SE10.

- Then you select your new created transport request, and "include objects" from another "local transport" request into it.

- Assign a "Target System" in the "properties tab" of the transport request.

- Release your transport request

- tadam !! the cofiles & data files are created and ready to be copied at the OS level or manually include in a transport queue if the target system share the same transport directory.

Cheers