| Author |
 Topic  |
|
|
jsmith8858
Dr. Cross Join
USA
7423 Posts |
 Posted - 09/28/2006 : 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 |
Edited by - jsmith8858 on 09/28/2006 09:16:35
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
Posted - 09/28/2006 : 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 - 09/28/2006 : 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)
USA
6997 Posts |
Posted - 09/28/2006 : 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 |
|
|
|
jsmith8858
Dr. Cross Join
USA
7423 Posts |
Posted - 09/28/2006 : 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
USA
7423 Posts |
Posted - 09/28/2006 : 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
United Kingdom
22191 Posts |
Posted - 09/28/2006 : 15:39:34
|
Not such a twit after all then ...  |
|
|
|
jsmith8858
Dr. Cross Join
USA
7423 Posts |
Posted - 09/28/2006 : 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)
USA
6997 Posts |
Posted - 09/28/2006 : 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
Sweden
29138 Posts |
Posted - 09/29/2006 : 00:39:09
|
This topic is great to read!
All classic sentences from both intellectual-impaired and geniuses are here
Peter Larsson
Helsingborg, Sweden |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 09/29/2006 : 01:19:52
|
"I was going to go back and delete my original post and replace it with ..."
|
|
|
| |
Topic |
|
Transactional Replication -- Adding new Table
