publisher, distributor, subscriber all on one box?

has anyone done this? I need to test something and thought I would give
this a try...
tia
-comb
I do it all the time.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"combfilter" <asdf@.adsf.com> wrote in message
news:MPG.1cfeab14ad684989697@.news.newsreader.com.. .
> has anyone done this? I need to test something and thought I would give
> this a try...
> tia
> -comb
|||In article <eU3NT3YYFHA.3584@.TK2MSFTNGP12.phx.gbl>,
hilary.cotter@.gmail.com says...
> I do it all the time.
>
so do i set it up just under the configure replication... in enterprise
manager? is there anything special i need to do? Is there a smarter
way to move tables from one db to another continually?
Thanks,
-comb
|||Yes, and what do you mean by move tables continuously? For this possibly log
shipping is the best as it will mirror objects with no intervention, but
your destination will have to go off line and must be treated as read only.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"combfilter" <asdf@.adsf.com> wrote in message
news:MPG.1cff9d563dc5267e989698@.news.newsreader.co m...
> In article <eU3NT3YYFHA.3584@.TK2MSFTNGP12.phx.gbl>,
> hilary.cotter@.gmail.com says...
> so do i set it up just under the configure replication... in enterprise
> manager? is there anything special i need to do? Is there a smarter
> way to move tables from one db to another continually?
> Thanks,
> -comb
|||In article <eBEXevgYFHA.1796@.TK2MSFTNGP15.phx.gbl>,
hilary.cotter@.gmail.com says...
> Yes, and what do you mean by move tables continuously? For this possibly log
> shipping is the best as it will mirror objects with no intervention, but
> your destination will have to go off line and must be treated as read only.
They are historical tables that are updated throughout the day. See the
db has about 750 tables in it, I am only needing to replicate about 4 of
them. That is why I 86'd the idea of logshipping. I thought with log
shipping it was an all or nothign type deal? Like the entire db or
nothing at all.
Thanks for any advice.
comb