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 |
|
fvinagre
Starting Member
29 Posts |
 Posted - 2004-10-11 : 04:12:19
|
| -------------------------------------------------------------------------------- Dear DBASI would like, transfer data from a simple query to other database in other server without link the destination serverRegardsFernando |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-11 : 04:30:55
|
quote:
Originally posted by fvinagre
-------------------------------------------------------------------------------- Dear DBASI would like, transfer data from a simple query to other database in other server without link the destination serverRegardsFernando
as in no link?backup the database, restore into the target server, query the data you need.or you mean using DTS? but this also uses linked server |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-10-11 : 04:31:08
|
without link??you need either linked servers (look it up in BOL = Books OnLine = SQL help)or backup db, burn in on cd and take to the remote server and restore it there from the cd...Go with the flow & have fun! Else fight the flow  |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-10-11 : 04:31:35
|
so close...   Go with the flow & have fun! Else fight the flow |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-11 : 04:32:36
|
| well i think our connection is improving? |
|
|
|
fvinagre
Starting Member
29 Posts |
Posted - 2004-10-11 : 05:15:49
|
| I only want to know if is posible make another using Transact SQL from Query analizer or other program. To copy data from a query from one server to other server. Without using linked servers funcionality on SQL Server. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-11 : 05:21:41
|
quote:
Originally posted by fvinagre
I only want to know if is posible make another using Transact SQL from Query analizer or other program. To copy data from a query from one server to other server. Without using linked servers funcionality on SQL Server.
you can produce the DML for the data then apply the file to the other server. but otherwise, based on my limited experience, there must be a link if you're using qa and issuing some queries. |
|
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2004-10-11 : 05:28:44
|
| You can do it with a DTS Transform Data Task without linked servers.Mark |
|
|
|
|
|
|
Transfer data between servers