how to transfer data from one sql server pc to another sql s

Question

hello friends... i have two server named server-A and server-B. both servers have sql server 2008 and have same editions. i need to transfer table data from server-A to server-B. how to solve this?

Khan Abrar Ahmed · Answer

Hi you have to use the linked server feature please refer the below link http://msdn.microsoft.com/en-us/library/ff772782.aspx http://technet.microsoft.com/en-us/library/ms186839%28v=sql.105%29.aspx http://msdn.microsoft.com/en-us/library/ms188279.aspx