PROD to CRP

jdcmwilson

Well Known Member
I am wanting to copy my business data, versions, setup data from my PROD
environment to my CRP environment. Can someone tell me the best way and
what tables I should copy.

What happens if I copy all of JDE_PRODUCTION and JDE_PRODB733 to JDE_CRP and
JDE_CRPB733?

Thanks in advance for your assistance.



OW B73.3.2 SP10
NT 4.0 Enterprise Server
NT 4.0 Deployment Server
6 FAT clients

James Wilson
CNC Consultant

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com



All views are expressly my own and in no way reflect those of my employer.
 

DHelsle

Active Member
The JDE answer is R98403. If you have a DBA they can write a script using
SQL truncate to clear and insert to copy. This will run in 5 to 10% of the
time R98403 would take.

Business data is easy.

Copy the contents of all tables from JDE_PRODUCTION to JDE_CRP.
Copy both users PRODDTA and PRODCTL. This gets all control tables as
well.

Versions are trickier. Because parts of the information for batch versions
is kept in the spec files I recommend using object transfer.

Now if you're looking to move programs as well then you can copy the
contents of JDE_PRODB733. You'll need to move some data on the deployment
and enterprise servers too if this is what you need. Look at the upgrade
guide instructions for moving path codes after an upgrade.

David Helsley
(317)879-4483 dhelsle@iccnet.com (client)
(859)466-6746 ddh@consultant.com (me)

>
 

scott_zuke

Member
I've always performed these tasks using the R98403 batch job. I've played
around with doing it behind the scenes, but you often get into issues with the
table owner, etc.

I make copies of the following R98403 versions and tweak them as needed:
XJDE0019 Copy Specification Files
XJDE0021 Copy Business Data
XJDE0022 Copy Control Tables

Once you've setup the specific R98403 versions you need, you can put these jobs
on a schedule in order to update CRP on a regular basis.

Scott Zuke
 

Toni_Nanneman

Active Member
Scott, do you run these locally? I do the behind the scenes save and
restore and have constant problems not to mention that my specs don't get
updated. Do you have any documentation or does JDE have any 'useful'
documentation on this process?

Toni
OW B7322 sp12.2
 

jdcmwilson

Well Known Member
THANK YOU LIST!

I too was having problems doing the copy behind the scenes (table owner,
etc.) so I have resorted to using the R98403 vers 21 and 22 (made my own
copies) and I have had good success.

Thanks again,
James


>From: scott zuke <scott.zuke@marchfirst.com>
>Reply-To: jdelist@jdelist.com
>To: jdelistml@jdelist.com
>Subject: Re: PROD to CRP ~~4163:4175
>Date: Wed, 17 Jan 2001 14:05:48 -0800 (PST)
>
>I've always performed these tasks using the R98403 batch job. I've played
>around with doing it behind the scenes, but you often get into issues with
>the
>table owner, etc.
>
>I make copies of the following R98403 versions and tweak them as needed:
>XJDE0019 Copy Specification Files
>XJDE0021 Copy Business Data
>XJDE0022 Copy Control Tables
>
>Once you've setup the specific R98403 versions you need, you can put these
>jobs
>on a schedule in order to update CRP on a regular basis.
>
>Scott Zuke
>
>
>
>
>
>--------------------------
>To view this thread, visit the JDEList forum at:
>http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=4175
>*************************************************************
>This is the JDEList One World / XE Mailing List.
>Archives and information on how to SUBSCRIBE, and
>UNSUBSCRIBE can be found at http://www.JDELIST.com
>*************************************************************
>

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com



All views are expressly my own and in no way reflect those of my employer.
 

Adrian_Chimirel

Legendary Poster
Re: RE: PROD to CRP

Yes Toni,
JDE has some ... hum ... 'useful' documentation: the B733 "R98403 Environment Copy.doc".
I might send it to you/anybody else, if you want. Of course, you'll need to provide your address (I didn't see any on your Forum Profile)
Adrian

LIVE: B732.1 SP12.2, Oracle 805
SANDBOX: XE SP3, 8i
RS/6000, Citrix, 200+ clients
 
Top