sql server replication: Best way to replicate my situation -- sql server replication

Best way to replicate my situation

Diane
8/23/2007 1:08:01 PM

sql server replication:

I have a Database at Location A that I want to Replicate to Location B once a
day at the end of the day.

Location B is really just for information purposes only EXCEPT 1 table which
gets updated during the day. I was thinking I could export the ne data daily
out and import it into A and then Replicate A to location B.

Is this feasible? Is there a better way to think about this?

Thank you for your help.

Regards,

Re: Best way to replicate my situation

Hilary Cotter
8/23/2007 11:25:06 PM

If the table is relatively small use snapshot replication, otherwise use
transactional replication and schedule the agent to run once a day.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

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
[quoted text, click to view]