Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

Copy data from Production environment to Test environment

27 Replies

1 Subscribed to this topic

29 Subscribed to this forum

Sort:

Author

Messages

John Henley

Posts: 3366

New Poster

Engaged Reader

Avid Reader

4/14/2011 7:26 PM

EricS is absolutely correct.

Sampath S

Basic Member

Posts: 17

4/15/2011 8:28 AM

Be sure of the customized tables; suppose if you are copying the complete data along with the tables structure, then if you any new custom tables defined in your test servers will be gone.

val

Basic Member

Posts: 8

8/22/2011 8:47 PM

Here is how I refresh data in a product line on the test server, with all data from the prod product line on the production server (Our DB is Oracle)...

On Lawson Test App Sever:
Delete tables and data in :
bldora10ddl -UD

On DB Server
Export ORACLE_SID=PROD (or whatever your production instance SID is)
Export data :
exp file=prod.dmp owner=LAWPROD (<--prod database user name) statistics=none indexes=n log=exp.log

On DB Server
export ORACLE_SID=TEST
Import data :
imp file=prod.dmp fromuser=LAWPROD touser=LAWTEST (<--test database username) statistics=none indexes=none rows=y log=imp.log

On Lawson Test App Server
Build Indexes
bldora10ddl -URI

On Lawson Test App Server
Verify Database is Valid
verifyora10