Update test db, not copy

[cathyg18]

This is a really really basic question from a relative newbie.

I have a production database and a test database. Once a month, I want to UPDATE the test database with changes in various tables that have taken place since the last time. How do I do this? It's not really append, because some records have actually changed. I don't want to drop the tables and copy everything over again each month, because it's cumbersome, and I want to retain some modifications I've made to the test db that aren't present in the production db.

How do I do this?

Thanks in advance,

Cathy

 

[JayKusch]

May want to create a DTS Package that uses a "Copy SQL Server Objects" step.

Thanks

J. Kusch