Home » Server Options » Replication » What is the best way to replicate the data?
What is the best way to replicate the data? [message #75442] Mon, 05 January 2004 09:58 Go to next message
Jadie
Messages: 64
Registered: January 2002
Member
I want to replicate some data from the production database to another database using by Marketing department. These data will be selected from some tables that meet some selection criterias.

Can anyone tell me what is the best way to do it? Appreciate any response!!! Thanks.

Jadie
Re: What is the best way to replicate the data? [message #75444 is a reply to message #75442] Tue, 06 January 2004 01:53 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

You can use a Materialized View (Snapshot).

Look-up the "CREATE MATERIALIZED VIEW" statement in the SQL Reference Guide.

Best regards.

Frank
Re: What is the best way to replicate the data? [message #75525 is a reply to message #75444] Wed, 28 July 2004 02:45 Go to previous message
M.werasinghe
Messages: 1
Registered: July 2004
Junior Member
i want to sent some data over the dial-up connection
by using SQL server 2000 if someone know about that place inform it
Previous Topic: Materialized views
Next Topic: why I use sqlplus internal, but the system ask me the passwd?
Goto Forum:
  


Current Time: Thu Mar 28 18:31:57 CDT 2024