Prev
Next
Forums Financial Management Lawson Services Automation (PSA/SA)

PSA database copy

 0 Replies
 0 Subscribed to this topic
 4 Subscribed to this forum
Sort:
Author
Messages


Mike LaCosse











Basic Member



Posts: 6




Basic Member



3/23/2006 3:30 PM
    We are trying to restore our development data from production. We can easily do this for our backoffice data using database tools or expsysdb, but Lawson provides no documentation for copying a PSA database from one server to another (different DB names).

    We have tried a full "restore" of the PSA production database to development, but doesn't work because the database name "PSAPRD" is hard-coded into views, stored procedures, and user-defined functions. This causes problems since our development database is named PSADEV". File ownership is also incorrect.

    We have also tried truncating the PSA development data and copying just the data, but this was troublesome due to data dependencies.

    Has anyone done this before?