on 03-22-2006 12:44 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.