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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Copy a PervasiveSQL 9 Database
- Thread starter EMax1
- Start date
There is no way, with Pervasive tools, to create a script of the database.
If you are wanting to copy the entire database including the data, simply copy the files (all of the DDF files and the data files) to the new machine and recreate the DSN/Database Name.
If you want empty copies of the tables, you can do the same process then use BUTIL -CLONE to create empty versions of the data files (not the DDFs). Rename the Clones to the original name and you've got an empty database.
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.
If you are wanting to copy the entire database including the data, simply copy the files (all of the DDF files and the data files) to the new machine and recreate the DSN/Database Name.
If you want empty copies of the tables, you can do the same process then use BUTIL -CLONE to create empty versions of the data files (not the DDFs). Rename the Clones to the original name and you've got an empty database.
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.
- Status
Similar threads
- Locked
- Question