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 |
|
|
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. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-09-28 : 15:00:35
|
quote: Originally posted by jsmith8858I have a doubt. How do u get teh table to replicate? thx!
Do all replcation in the front-end!CODO ERGO SUM |
|
|
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 |
|
|
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 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-09-28 : 15:39:34
|
Not such a twit after all then ... |
|
|
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 |
|
|
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 |
|
|
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 LarssonHelsingborg, Sweden |
|
|
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 ..." |
|
|
|