April 16, 2008 at 9:06 am
All,
We have a need to replicate data from server prod, to dev, daily. Both servers are running Windows server 2003 and SQL 2005. The prod database is 100 GB with approximately 4,000 tables. I do not need to replicate views, sp etc.
I am thinking of configuring snapshot replication. on prod, I would have the publisher and distributor, and on dev I would have a subscriber which would pull once a day at night, from the publisher.
Is snapshot replication the best approach to accomplish this?
Thank you for your input.
Andre
April 20, 2008 at 8:51 pm
Just my input for your reference.
I would like to say, snapshot is not a good candidate. You can use export data to your target server by selecting desired objects. Replication is harder to maintain than other approaches.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply