Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hornet
Yak Posting Veteran
96 Posts |
 Posted - 2006-06-02 : 01:55:27
|
Hi all!I have 2 server registrations from different computers on my SQLServer. I need to insert data from first PC to second. (e.g. From table A on first PC to table B on another)How can I do it?Only using linked server?Thanks in advance! |
|
|
rob_farley
Yak Posting Veteran
64 Posts |
Posted - 2006-06-02 : 02:10:51
|
| Linked Server is quite easy. But you could always push the data around using SSIS. I guess it depends on what kind of thing you're trying to achieve.Rob Farleyhttp://robfarley.blogspot.com |
 |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-06-03 : 00:54:32
|
| Linked Server is usefull when you are trying to insert through T-SQL, but you can use Data Transformation Service tool(DTS) for migrating the data.If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them. |
|
|
|
|
|
|
Inserting data from one server db to another