question-synch

microsoft.public.sqlserver.programming

22 Jun 2006 9:49 AM

P Platan

Hello!

We have 2 databases.An old one which has the old schema and the new one
which has the schema that we want to go for.
We are in the middle of the transition and by using triggers we keep them
updated.

In the new database we want to make a change in a table.-> add an identity
field as primary key and add 2 fields.
I was wondering if while we do that,the old database has
inserts,updates,deletes (it must be online 24/7 I cannot turn it off or drop
the triggers temporarily) that affect this table ,will we have just a table
lock and when the operation is finished the data from the triggers will
update the new db or we may loose data?

sorry for my poor english

Thanx in advance