Forums
Lawson Services Automation (PSA/SA)
PSA database copy
Author
Messages
Mike LaCosse
Basic Member
Posts: 6
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?