Groups | Blog | Home
all groups > sql server replication > july 2006 >

sql server replication : Database for testing purposes


Abhi
7/20/2006 7:57:02 AM
Hi,

We are planning to move our production database to a test server and were
thinking what would be the right way to do it? We want to replicate the data
nightly. Would peer-to-peer replication be the way to do it?

Thanks,

Abhi
7/20/2006 8:37:02 AM
Cool thanks Paul.

Abhi

[quoted text, click to view]
Hilary Cotter
7/20/2006 1:03:42 PM
If you want dev synchronized with production use transactional replication.
If you need an image of production use a backup and restore.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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]

Paul Ibison
7/20/2006 4:25:41 PM
Abhi,
definitely not peer-to-peer. If the testing is read-write, then snapshot
replication would probably be the way to go. Alternatively a 'database
shipping' custom setup.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

AddThis Social Bookmark Button