I have a requirement to send data from my database to another databse which is in different server. I want to do it using trigger. Can you please guide me how to do this. In case there is any other better method available then please let me know.
Senthil Kumar C ------------------------------------------------------ MCITP - Database Administration SQL SERVER 2008 MCTS - Database Development SQL SERVER 2008
I did not get any useful Info from searching High Availability in BOL. I just want to know if its technically possible in SQL server 2008 to transfer data from database in one server to database in another server. I have a table in Server A and I want to write a trigger on the table to update the data in a table in server B. How can i do it using triggers or do I need to use some other method.
I want the update to happen in server 2 whenever there is update in table in first server. So I cant use import export. Can I use linked server inside trigger?
I want the update to happen in server 2 whenever there is update in table in first server. So I cant use import export. Can I use linked server inside trigger?
You are confusing...
You want to use trigger go ahead.
If you are going to transfer the Whole Database (All table) Go for Database Mirrioring.
If you want specific table/specific column in a table go for Replication.
Senthil Kumar C ------------------------------------------------------ MCITP - Database Administration SQL SERVER 2008 MCTS - Database Development SQL SERVER 2008
Senthil, I have requirement to update only 1 table from server 1 to server 2. Update in server 2 should happen when there is update in server 1 table. Now how do I access the table in server 2 database inside the trigger. Will replication solve this?
Need help on data transfer from one server to anot
Posted - 11/28/2012 : 23:25:28
