Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to make a copy of a pervasive database

Status
Not open for further replies.

tbscmgi

MIS
Sep 17, 2003
66
US
I have a pervasive database call sqn which is my production database. I want to make a copy of my production database as sqndev for testing, on the same server.

I have no idea how to do this HELP Please.

Thanks
Tony

ettienne (TechnicalUser) 25 Jun 09 8:42
You can copy the contents of the data folder to a new data folder, say sqn\*.* to sqndev\*.*, and then setup the new database in PCC.

I try that, but when I try to view the property of any table I'm getting the following errors:
error retrieving stat information on the table.
warning index definitions for table xxx do not match the physicial file.
On the general tab there is no info (blank).

When I double click on any table I'm getting the following error: The ri definitions is out of sync and btrieve error 73.

Thanks
Tony
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top