Home » Server Options » Replication » new fields in an already replicated table
new fields in an already replicated table [message #366470] Mon, 19 July 1999 14:58
ron
Messages: 50
Registered: July 1999
Member
We currently have a number of tables on one server replicating into another server (datamart) in the form of snapshots. We are making some changes to the database tables that are being replicated from the primary server and we want to have those fields included in the snapshots. Because we have a significant amount of data in the datamart already, we do not want to have to drop the snapshot, recreate the snapshot with the new fields, and replicate ALL the data again. Is there anyway to change the snapshot query to include the new fields so that it will begin bringing these values over, WITHOUT dropping and recreating the snapshot?
Previous Topic: Snapshot Replication
Next Topic: if mas def site fails
Goto Forum:
  


Current Time: Thu Mar 28 15:10:04 CDT 2024