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 |
pnasz
Posting Yak Master
101 Posts |
Posted - 2012-11-11 : 00:53:21
|
How to we transfer data from one Database which is in X server to another database which is in y server usinq sql command |
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-11-11 : 02:01:42
|
A few different methods:1) Create a Linked Server, and then run query in SSMS2) SSIS 3)Export to flat file and reimportThe method you use will depend on the specific circumstancesJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|