BV 2013 DB Migration

SOLVED

I have a need to move the database to a new server. I am having great difficulty in finding anything that covers the Pervasive portion. Hoping someone here has some documentation they could share.

Thanks,
Aaron.

Parents
  • +1
    verified answer

    Since the responses I received on here were utterly useless and didn't in any way even attempt to answer my questions, I figured it out on my own. Here's what I had to do, for any one in a similar situation.

    1. Install Pervasive Workgroup on the new file server (database server). Do all interaction through the server console and not through RDP or you may run into issues.

    2. Create blank folders where your new database locations will be. Open up CC and create new databases named the same as the ones you wish to migrate and located in the blank folder you just created.

    3. Kill the pervasive service on the new server. Old server too. Copy all of the files from the old database locations to the new. Delete any lock ~PVSW~.LOC files in those directories.

    4. Fire Pervasive back up. In my case it read all the new data files just fine.

    5. In BV, add the new locations to the company list.

    6. Validate.

Reply
  • +1
    verified answer

    Since the responses I received on here were utterly useless and didn't in any way even attempt to answer my questions, I figured it out on my own. Here's what I had to do, for any one in a similar situation.

    1. Install Pervasive Workgroup on the new file server (database server). Do all interaction through the server console and not through RDP or you may run into issues.

    2. Create blank folders where your new database locations will be. Open up CC and create new databases named the same as the ones you wish to migrate and located in the blank folder you just created.

    3. Kill the pervasive service on the new server. Old server too. Copy all of the files from the old database locations to the new. Delete any lock ~PVSW~.LOC files in those directories.

    4. Fire Pervasive back up. In my case it read all the new data files just fine.

    5. In BV, add the new locations to the company list.

    6. Validate.

Children
No Data