Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Transfer data between 2 servers

Status
Not open for further replies.
aspvbnetnerd

aspvbnetnerd

Programmer
May 16, 2006
278
SE
Hi,
Is there any possible way to transfer data from one MS SQL Server to Another MSSQL Server with a query.

George
 
Sort by date Sort by votes
I think you want to have a look at linked servers, and the OPENQUERY method.

Hope this gets you started,

Alex

Ignorance of certain subjects is a great part of wisdom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

botatun
  • Locked
  • Question
the linked server insert data to csv in wrong order
Replies
0
Views
147
botatun
botatun
johnb1023
  • Locked
  • Question
Date conversions between Microsoft SQL Server and Viewing in MS Access
Replies
0
Views
229
johnb1023
johnb1023
smsmail
  • Locked
  • Question
How to import EXCEL data into existing table in SQL Server
Replies
5
Views
283
markjoseph1232
markjoseph1232
Webkins
  • Locked
  • Question
SQL Server 2000 data redundancy question
Replies
1
Views
59
mrdenny
mrdenny
rss0213
  • Locked
  • Question
data transformation of BIN data?
Replies
0
Views
53
rss0213
rss0213

Part and Inventory Search

Sponsor

Back
Top