Sync data Bi-Directional Automatically- Sql Server 2008
-
I have table(Tbl_A) in Server1 whenever DML(Insert/Update/Delete) operation happens in Tbl_A it has to be automatically insert/Update/Delete into Table B,C(Tbl_B,Tbl_C) in different sever2. 'Whenever Table B,C Update/Delete/Insert record automatically record in Table A(Tbl_A). I tried trigger but it does not help work for me. Please advice me how to deal this scenario. Thanks Rao
Thanks & Regards Rao
-
I have table(Tbl_A) in Server1 whenever DML(Insert/Update/Delete) operation happens in Tbl_A it has to be automatically insert/Update/Delete into Table B,C(Tbl_B,Tbl_C) in different sever2. 'Whenever Table B,C Update/Delete/Insert record automatically record in Table A(Tbl_A). I tried trigger but it does not help work for me. Please advice me how to deal this scenario. Thanks Rao
Thanks & Regards Rao
-
Hi, Try sync Framework Reference : http://msdn.microsoft.com/en-us/library/bb902853.aspx[^]
-
I have table(Tbl_A) in Server1 whenever DML(Insert/Update/Delete) operation happens in Tbl_A it has to be automatically insert/Update/Delete into Table B,C(Tbl_B,Tbl_C) in different sever2. 'Whenever Table B,C Update/Delete/Insert record automatically record in Table A(Tbl_A). I tried trigger but it does not help work for me. Please advice me how to deal this scenario. Thanks Rao
Thanks & Regards Rao
Well, you could use the OUTPUT Clause instead of a trigger to capture the data to input to the other server, and send to the application that inserted the row to actually put it into the other server, never tried it but this might be worth a go if you wanna do it in pure T-SQL http://stackoverflow.com/questions/545364/tsql-command-to-connect-to-another-server-sql-server-2005[^]
-
I have table(Tbl_A) in Server1 whenever DML(Insert/Update/Delete) operation happens in Tbl_A it has to be automatically insert/Update/Delete into Table B,C(Tbl_B,Tbl_C) in different sever2. 'Whenever Table B,C Update/Delete/Insert record automatically record in Table A(Tbl_A). I tried trigger but it does not help work for me. Please advice me how to deal this scenario. Thanks Rao
Thanks & Regards Rao
I have no better idea about relevant of database but your problem will be solve at w3school site because of there is well explain about database...I also daily visit that site for getting new information about html...