Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Transactional Replication -- Adding new Table

Author  Topic 

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2006-09-28 : 08:55:16
Hi All --

I am not big on administration stuff, so be patient with me! I may be a twit ...

Running SQL 2000 ..... We have transactional replication set up. I have created a couple of new tables and now I'd like for them to be replicated. However, from what I've experienced and read, it seems that I need to re-initialize the subscription and re-send a snapshot to the replicated databases in order to add these new tables .. is that correct? Is there an easier/quicker way just to start replicating the two new tables?

translated for Peso:

I have a doubt. How do u get teh table to replicate? thx!


- Jeff

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-09-28 : 14:48:59
What I do to add a new table is drop replication then rebuild it.

But you can create a new article on the publisher, then push it to the subscriber. I prefer to use one article for maintenance reasons, although I believe they recommend one article per object for performance reasons.

Tara Kizer
Go to Top of Page

mcrowley
Aged Yak Warrior

771 Posts

Posted - 2006-09-28 : 14:55:29
The replication >should< be smart enough to initialize only the tables that are new to the publication. At least I think that is how it worked the last time I tried this. Been a while.
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-09-28 : 15:00:35
quote:
Originally posted by jsmith8858
I have a doubt. How do u get teh table to replicate? thx!


Do all replcation in the front-end!




CODO ERGO SUM
Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2006-09-28 : 15:21:43
quote:
Originally posted by mcrowley

The replication >should< be smart enough to initialize only the tables that are new to the publication. At least I think that is how it worked the last time I tried this. Been a while.



Yeah, I swear I got that work before as well, but I can't seem to get things to happen unless I mark it for initialization and then nothing happens until I re-run the snapshot agent which then uploads everything. I am just trying to avoid that and hoping maybe there were some specific steps that I should be taking.

I'll give it shot early tomorrow morning ...

- Jeff
Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2006-09-28 : 15:34:57
ah, I got it now. Don't mark for re-init. Just run the snapshot agent, and then run the distribution agent. That will then just send out the new articles.

Thanks for the input!

- Jeff
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-09-28 : 15:39:34
Not such a twit after all then ...
Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2006-09-28 : 16:45:46
I was going to go back and delete my original post and replace it with "SOLVED! NO THANKS TO SQLTEAM!" but I figured that would be too much!

- Jeff
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-09-28 : 17:02:42
Well It looks like no real help is coming
Thanks everybody for your help (80%)
Jeff will just have to figure out the remaining 20%




CODO ERGO SUM
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-09-29 : 00:39:09
This topic is great to read!
All classic sentences from both intellectual-impaired and geniuses are here


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-09-29 : 01:19:52
"I was going to go back and delete my original post and replace it with ..."
Go to Top of Page
   

- Advertisement -