I will answer this way:
-- This is a good question.
-- First of all, when you as replication at here, I need to understand clearly what you realy mean.
-- You can relplicate only one table, or you can replicate the whole schema of tables from one database (or location) to the remote place.
What are you asking about at here.
-- Regardless what you really want to ask, the answer is: Yes, when you replicate the data to remote place, you have consider the data change rate or DML rate in your source database (or table).
-- Different databse offers different tools for replciate data, what kind of database are you using at here?
-- If you are using Oracle:
-- For single table raplication, you can use Materialized View ( I do talk Materialized View in my class);
-- For multi tables replication you can use Oracle Stream;
-- Or you can set up a hot standby database in the remote site and open for Read Only when your user use it to run the report.
-- If the data change rate is too high, and you don't want the lead time is too long, you may have to purchase third party tool like Shareplex to do the replication.
-- Am I answering your question?
Thanks!
-- This is a good question.
-- First of all, when you as replication at here, I need to understand clearly what you realy mean.
-- You can relplicate only one table, or you can replicate the whole schema of tables from one database (or location) to the remote place.
What are you asking about at here.
-- Regardless what you really want to ask, the answer is: Yes, when you replicate the data to remote place, you have consider the data change rate or DML rate in your source database (or table).
-- Different databse offers different tools for replciate data, what kind of database are you using at here?
-- If you are using Oracle:
-- For single table raplication, you can use Materialized View ( I do talk Materialized View in my class);
-- For multi tables replication you can use Oracle Stream;
-- Or you can set up a hot standby database in the remote site and open for Read Only when your user use it to run the report.
-- If the data change rate is too high, and you don't want the lead time is too long, you may have to purchase third party tool like Shareplex to do the replication.
-- Am I answering your question?
Thanks!