Hi
I have around 7 tables that get new data or updates in the production envt
and I would like to insert/update these tables on a daily basis in the
testing environment. Can you suggest a script to do this.
Thanks
Bob

Can you identify the rows?

You could store the row keys in a table and the action performed thereon
so that at synchronisation time you can look to pull only the rows you
need from the production environment and you will know what action you
need to perform also.

On way of kepping things in sync is replication but I would not
recommend that between environments like this.

Allan




"Bob" <Bob (AT) discussions (DOT) microsoft.com> wrote

First identify the fields that will determine if it's a new or existing record.
Update the existing records using a JOIN with those fields
Insert the new records using a LEFT JOIN WHERE keys from destination are NULL

"Bob" wrote:

Bob wrote:
Ya, I would avoid replication unless it's absolutely necessary--too
much overhead. Personally, I would look at setting up logshipping and
applying the changes to your development server via log restores.

Brett



--
arbert
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------