bojimuncher
IS-IT--Management
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!