{"id":1375,"date":"2013-11-25T14:59:59","date_gmt":"2013-11-25T14:59:59","guid":{"rendered":"http:\/\/turtlellc.com\/?p=1375"},"modified":"2017-09-22T19:59:02","modified_gmt":"2017-09-22T19:59:02","slug":"recover-existing-bpc-ms-appsets","status":"publish","type":"post","link":"https:\/\/www.turtle.works\/knowledge\/recover-existing-bpc-ms-appsets\/","title":{"rendered":"Recover Existing BPC MS AppSets"},"content":{"rendered":"

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.<\/p>\n

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:<\/p>\n

    \n
  1. AppServer Database<\/span>\n
      \n
    1. Add a row to AppServer.dbo.tblAppSetInfo
      \n\"tblAppSetInfo\"<\/a><\/span><\/li>\n
    2. Add a row to AppServer.dbo.tblAppSetAccess setting <domain>\\BPCSysAdmin as the UserID<\/li>\n<\/ol>\n<\/li>\n
    3. App Set Database Tables. Only add rows to the following tables, if they don’t exist for <domain>\\BPCSysAdmin\n
        \n
      1. tblUsers
        \n        \"tblUsers\"<\/a><\/li>\n
      2. UserTeamAssign
        \n        \"UserTeamAssign\"<\/a><\/li>\n
      3. tblAppAccess
        \n        \"tblAppAccess\"<\/a><\/li>\n<\/ol>\n<\/li>\n
      4. App Set Database Security. Make sure:\n
          \n
        1. <domain>\\BPCUser has db_datareader and db_datawriter access to the database
          \n          \"BPCUser<\/a><\/li>\n
        2. <domain>\\BPCAdmin has db_owner access to the database
          \n          \"BPCAdmin<\/a><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

          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.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-1375","post","type-post","status-publish","format-standard","hentry","category-bpc"],"_links":{"self":[{"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/posts\/1375","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/comments?post=1375"}],"version-history":[{"count":1,"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/posts\/1375\/revisions"}],"predecessor-version":[{"id":1708,"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/posts\/1375\/revisions\/1708"}],"wp:attachment":[{"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/media?parent=1375"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/categories?post=1375"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/tags?post=1375"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}