Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Transactional replication challenges.

 
   Database Help (Home) -> Replication RSS
Next:  Visio Template For Illustrating OLAP Schemas  
Author Message
Uncle_enzo

External


Since: Oct 09, 2008
Posts: 2



(Msg. 1) Posted: Thu Oct 09, 2008 7:27 am
Post subject: Transactional replication challenges.
Archived from groups: microsoft>public>sqlserver>replication (more info?)

Hi, I have a problem that I have run into with SQL transaction replication. I
work for an ASP that hosts an oracle application called JD Edwards Enterprise
one.

When updates are applied (ESU) to the app, any DDL statements that run that
add or alter indexes or columns fails with a marked for replication message.
Only way around this that I can see is to drop the publication and
subscription and recreate it.

Using the snapshot is not an option due to limited bandwidth, T-1. The
entire database is replicated and is 150GB. With that being said I also will
need to get these changes over to the subscriber database. Is there any other
way to do this without dropping the publication?

Ideally I would like the application to make the changes instead of manually
running the sql statements. But I don’t know if this is possible. Biggest
challenges I see is getting this to work without having to do a manual
resynchronize replication subscriptions.

Replication was setup using KB320499.

SQL 2000EE SP4
Windows 2003 EE SP2

Server A, Publisher with push subscription, Seattle
Server B, Subscriber , Georgia

Thanks for your time.

 >> Stay informed about: Transactional replication challenges. 
Back to top
Login to vote
Paul Ibison

External


Since: Oct 03, 2008
Posts: 104



(Msg. 2) Posted: Thu Oct 09, 2008 7:56 am
Post subject: RE: Transactional replication challenges. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

You could alter the scripts to use sp_repladdcolumn and sp_repldropcolumn.
For column changes, please look here:
http://www.replicationanswers.com/AddColumn.asp
HTH,
Paul Ibison (www.replicationanswers.com)

 >> Stay informed about: Transactional replication challenges. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Combining Transactional Replication and Merge Replication - I would like to know if this scenario is possible: I have main database (Server A) that I replicate to another server using transactional replication (Server B), know I would like to publish this database on Server B as a merge publication and then...

Can you have transactional replication of blobs? - I am having an issue using transactional replication on a SQL 2005 SP2 system when trying to replicate an Image data type. The data won't write to the Prod system, let alone replicate. However, when I remove the table from the publication everything..

Bidirectional Transactional replication - Hi All Do any one know where to get good Knowledge resources for writing and implementing stored procedures for bidirectional transactional replication. I f any body has one implemented recently can you spare the steps involved and the best practises....

UDFs & Transactional Replication - I created a UDF... create FUNCTION dbo.WhatLocationIsThis() RETURNS numeric AS begin declare @return as numeric SELECT @return = Location FROM storemain..tblLocationTable return @return end GO When I run 'select dbo.WhatLocationIsThis()' it..

Schema changes screw up transactional replication - Hi We have two servers with SQL Server 2005, version 9.0.3042 on both. There is a transactional replication between them but when we make schema changes on the publisher something goes wrong. We get this error message Subquery returned more than 1..
   Database Help (Home) -> Replication All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]