Replicating changed DB

From: news.microsoft.com (markNOSPAM_at_sitereportsltd.com)
Date: 05/18/04 

Date: Tue, 18 May 2004 12:04:48 +0100

Hi,

I have an SQL 2k database on a dedicated server in another city which I need
to replicate to a backup server in the office. The replication aspect is not
a problem except that the database tables are changed from time to time,
sometimes a new column or changing an existing column. Whilst we do have a
development database, the changes still need to go live at some stage. As EM
will not allow me to drop a specific article I have to resort to dropping
the publication and re-creating it. With a 20gb database this is not a 5
minute job and it takes 2-3 days to re-sync the backup. There must be a way
to replicate structural changes to a database, without scrapping a 20gb
snapshot and re-building. Surely it is just a case of replicating the alter
table statements(s)?

We are using transactional push replication (we have problems getting pull
to work through ISA) between two SQL 2k servers

Any help greatly appreciated, thanks.

Mark Leavesley

Relevant Pages

  • RE: 2K3 Replication error - tombstone lifetime
    ... it seems ur AD database is not uptodate or u have restored server before ... if ur backup is 60 days old than there is no way u can restore ur AD ... > The Active Directory cannot replicate with this server because the time ...
    (microsoft.public.windows.server.active_directory)
  • Re: Possible Public Folder Corruption
    ... I woud'nt worry about any corruption being replicated, ... database on your 5.5, create a new pf db and replicate from your Ex2k3. ... mailboxes are still located on the ek55 server with only 5 on the ek23 ...
    (microsoft.public.exchange.admin)
  • Re: RFS, Replication and UniData
    ... the database will replicate on another server ... updated before the master records are written and then the server ... You need transaction logging of some form using logical transaction ... to the database in a logical group and then end the transaction. ...
    (comp.databases.pick)
  • Re: on-line and near-line databases
    ... 'B' database) and only keep users from the last 30 days in the ... data restoration approach. ... Copy the records in the subscriber database which are to be ... ready and we 'replicate the execution of the ...
    (microsoft.public.sqlserver.replication)
  • Re: How to setup reporting database
    ... Yes, you can replicate View, Procs, etc. but then you need a new snapshot ... > reports that generate high utilization on the server. ... > to do that without modifying the current database or application? ... > PK's be added easy or does it mean that they would have to modify the ...
    (microsoft.public.sqlserver.server)