SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Need help on data transfer from one server to anot
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sqln
Starting Member

India
4 Posts

Posted - 11/28/2012 :  23:25:28  Show Profile  Reply with Quote
Hi,

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.

Regards

senthil_nagore
Flowing Fount of Yak Knowledge

India
1007 Posts

Posted - 11/29/2012 :  00:18:19  Show Profile  Visit senthil_nagore's Homepage  Send senthil_nagore a Yahoo! Message  Reply with Quote
Read about High Availability in BOL

Senthil Kumar C
------------------------------------------------------
MCITP - Database Administration SQL SERVER 2008
MCTS - Database Development SQL SERVER 2008
Go to Top of Page

srimami
Posting Yak Master

160 Posts

Posted - 11/29/2012 :  01:05:14  Show Profile  Reply with Quote
If both servers are on same domain, you can use linked server and write select into statement or use Import/Export wizard.
Go to Top of Page

sqln
Starting Member

India
4 Posts

Posted - 11/29/2012 :  01:29:09  Show Profile  Reply with Quote
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.
Go to Top of Page

sqln
Starting Member

India
4 Posts

Posted - 11/29/2012 :  01:31:51  Show Profile  Reply with Quote
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?
Go to Top of Page

senthil_nagore
Flowing Fount of Yak Knowledge

India
1007 Posts

Posted - 11/29/2012 :  01:41:08  Show Profile  Visit senthil_nagore's Homepage  Send senthil_nagore a Yahoo! Message  Reply with Quote
quote:
Originally posted by sqln

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
Go to Top of Page

sqln
Starting Member

India
4 Posts

Posted - 11/29/2012 :  02:30:19  Show Profile  Reply with Quote
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?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000