PSA database copy

You are not authorized to post a reply.

Mike LaCosse

Basic Member

Posts: 6

Basic Member

    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?
    You are not authorized to post a reply.