|
I am not sure can I use Triggers or not for our project, if I can't use triggers I think I can write a procedure to copy rows from primary database to secondary database and then delete the rows from primary database.
I have one more doubt, to copy rows from one table to other table using 'insert into table ....... select .. from othertable ....' can I copy rows from a table (in x1 databse on y1 system) to other table (in x2 database on y2 system)?
|