sql server replication: Development & Lives databases -- sql server replication

Development & Lives databases

Jon
1/13/2005 7:53:05 AM

sql server replication: Hello all, apologies if i've posted this in the wrong forum!

I have 2 databases development and live. Development has the correct
structure (SP's and tables) and live has the correct data. I would like to
make live match the development database but not to loose any data. Is
replication the best method?

If so, any simple www's that could help me?

Thanks all,

Re: Development & Lives databases

Hilary Cotter
1/13/2005 11:35:42 AM

you have to pick an authority. Sounds like you have to ensure that live has
the correct schema, and then push your live data to development.

Transactional replication is ideal for this. It does require that every
table has a pk though, which it should.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
[quoted text, click to view]