Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

Copy data from Production environment to Test environment

 27 Replies
 1 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Page 2 of 2 << < 12
Author
Messages
John Henley
Posts: 3353
4/14/2011 7:26 PM
    EricS is absolutely correct.

    Thanks for using the LawsonGuru.com forums!
    John
    Sampath S
    Basic Member
    Posts: 17
    Basic Member
    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
      Basic Member
      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
        Page 2 of 2 << < 12