Re: Replication Question

My experience with Enterprise Replication tells me you don't need to use it to solve this problem (hammer to swat a fly). ER is designed to replicated between multiple machines on a network located in different geographies. I would look at exporting your database and importing it into a different database. Since you are on the same machine, you can use Informix onunload, onload. Stick those in a script and cron that puppy and you should be fine. albert martinez wrote in message <36C45367.D8CBB72D@san.gva.es>... > >I have a database for OLTP (24h*7d) in ODS 7.23, and I need a replica >in the same machine for DSS and ODBC (read only) in order to separate >OLTP from DSS. The replica can be done in hours of low activity (from >2am to 6am). I need an automatic process to do so. >What is the best solution: data replication, an archive, ...? >Can anyone help me? > >Thanks >