INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

How to make a copy of a pervasive database

How to make a copy of a pervasive database

(OP)
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

RE: How to make a copy of a pervasive database

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.

RE: How to make a copy of a pervasive database

(OP)
ettienne-
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
   

RE: How to make a copy of a pervasive database

Looks like SQN has referential integrity and constraints enabled on the database. Unfortunately, unless SQN offers a way of making a test database you may be out of luck.  ONce you have RI, you either need to create a database with the same name as the original one (on a different machine) or disable RI, copy the database, then re-enable RI on the new database.  

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: How to make a copy of a pervasive database

(OP)
Since I'm new to this, do you know to disable RI?

Thanks
Tony

RE: How to make a copy of a pervasive database

Your best option is to actually go to SQN and tell them you want to create a test database.  
They may have SQL statements that will create the database and add the RI properly.

If you are set on doing it yourself, you'll need to use the DROP CONSTRAINT option on the ALTER TABLE statement. You'll need to do it for every table and every constraint.   

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close