Re: Replication with SE 7.14.UD1

Barry Stubbs <bgs@swweb.net> wrote in article > I need to replicate tables from one database to another. I know I am > somewhat limited with SE. Does anyone have a useful set of steps to do > this with SE. SE unfortunatly does not allow for communicating with two database simultaniously. There are two ways of doing this, depending on your needs. First: You best bet is to unload the data and pull dbschema's of the tables, close the database, and after opening the second then recreated and populate the tables in the second database. By writting SQL scripts, cron can be sheduled to execute this regularly. Secondly: This will only work if the tables are identical and the schema never changes. Using the schema from the source database, create the tables in the destination. In the source database, check the system catalogues for the filename used. Update the filename column in the destination database to point with the full path name to where the tables are in the source. For more specific details, email me. This can become rather lengthy if not understood. Dennis JR Harding (djrh@icon.co.za)