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.
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.
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.
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.
*Community Hub is the new name for Sage City