I recently built a new BPC application/web server. The existing App Sets were large; in the 2 billion rows category. So doing a backup and restore would be time consuming. The backup/restore was also unnecessary because the OSoft share was not on the app server and I wasn’t bringing up a new database server.
First I made a copy of the existing AppServer database. Then I did the BPC install. To bring the existing AppSets into the new environment I did the following for each App Set:
- AppServer Database
- App Set Database Tables. Only add rows to the following tables, if they don’t exist for <domain>\BPCSysAdmin
- App Set Database Security. Make sure: