PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 03/23/2006 10:30 AM by  Mike LaCosse
PSA database copy
 0 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Mike LaCosse
Private
Private
Basic Member
(12 points)
Basic Member
Posts:6


Send Message:

--
03/23/2006 10:30 AM
    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.