Development & Lives databases

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,
Jon
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
"Jon" <Jon@.discussions.microsoft.com> wrote in message
news:128F3236-EBD2-4034-8A3A-A72248CD3011@.microsoft.com...
> 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,
> Jon