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!
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
CODE
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
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