×
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!
  • Students Click Here

*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.

Students Click Here

Jobs

Daily Scheduled Exports or Mirror from Pervasive Server to Different Pervasive Server

Daily Scheduled Exports or Mirror from Pervasive Server to Different Pervasive Server

Daily Scheduled Exports or Mirror from Pervasive Server to Different Pervasive Server

(OP)
Hi all,

Recently started up in a new role that is using Pervasive DB to go along with their ERP system. They have a cpl servers running Pervasive fictitiously named ABC and ABCWEB. All of the main data from the ERP program is entered into server ABC Database GLOBAL but reports off of an internal website are ran off of ABCWEB. I would like to find a way to copy over a table on a nightly basis from ABC.GLOBAL.TABLENAME to ABCWEB.GLOBAL.TABLENAME so that the reports will have up to date data every morning, or if possible mirror the tables so that once data is being entered into the table on the main server ABC, that the data will also be in ABCWEB either immediately or on a scheduled interval.

I have tried rightclick exporting the table and rightclick importing the details into the ABCWEB server but it is a very large table with sales from 2013 and is not scheduled. I can use a select into statement to gather the details I need for the report into a new table, but then it is still cumbersome to export the data and import it into the table on the other server and still isnt scheduled based on my limited knowledge of the CLI. How is this generally done in psql?

Too new to pervasive to know what you might need to help me out but the Control Center version is 11.30 if it matters... Going to be changing systems fairly soon and not looking to upgrade or purchase products for the existing unless absolutely required.

Thanks!

RE: Daily Scheduled Exports or Mirror from Pervasive Server to Different Pervasive Server

Assuming both servers are running the Pervasive DB, you have a couple of options for creating a copy of the database. This simplest is to write a batch file to copy the DDFs and Data files that make up the Pervasive DB. However, if the files are open, that could lead to missing records. You can use Continuous Operation mode to backup the files. Once you put the files into Continuous Ops mode, you can copy the original files to the backup location, and then stop Continuous Ops mode. Something like:

CODE

butil -startbu pathtofiles\file.ddf
butil -startbu pathtofiles\field.ddf
butil -startbu pathtofiles\index.ddf
butil -startbu pathtofiles\datafile.mkd
...
xcopy pathtofiles\file.ddf newpath\file.ddf /Y
...
butil -endbu pathtofiles\file.ddf
butil -endbu pathtofiles\field.ddf
butil -endbu pathtofiles\index.ddf
butil -endbu pathtofiles\datafile.mkd 

You would need to list every PSQL data file (and DDF) you want to copy over. You can put the list into a List File and pass that on the -startbu / -endbu command like:

CODE

butil -startbu @FileList.lst 

Another option would be to write / have written / buy a program that copies the data from one database to another. You can use ODBC, Btrieve API, or any of the interfaces supported to write / have written. You could also use something like the Actian Data Integrator for a prebuilt solution.





Mirtheil
http://www.mirtheil.com

RE: Daily Scheduled Exports or Mirror from Pervasive Server to Different Pervasive Server

(OP)
Thanks a ton for the help, I'll try it out!

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! Already a Member? Login

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