sql - How to update a table copy in another database -

sql - How to update a table copy in another database -

i have 2 identical databases - 1 development (dev) , 1 production (prod) (both sql server 2008).

i have updated contents of table in dev , want sync corresponding table in prod.

i have not changed table schema, info within table (i have both changed existing rows , added new rows).

how can transfer changes in dev corresponding table in prod?

note, values in automatic identity column mgiht not match between 2 tables. however, know have made changes rows having same value in column.

martin

if don't want utilize replication, can create update, insert , delete trigger in dev database , update prod trigger. or can create view of dev database table on prod database.

sql sql-server-2008 synchronize