how can i read data from db on server to another db on another server

Question

I have two similar database with the same schema.But one is for printing purpose. My window form application needs to read data from dby on server1 to dby on server2.The servers are on different network but can communicate. Am trying to use subquery this is
query:

Using main_db
Insert into socio_bio 
select * from socio_bio where receiptno in (
)

What database system, and which version?? SQL is just the Structured Query Language - a language used by many database systems, but not a a database product... features like this is often vendor-specific - so we really need to know what database system you're using.... — marc_s
– marc_s, Commented Jul 25, 2012 at 10:02
Thanks - that should be something you always put in your tags to make things clear! — marc_s
– marc_s, Commented Jul 25, 2012 at 10:54

Dereli · Accepted Answer · 2012-07-25 10:13:02Z

2

You can use this stored procedure: sp_addlinkedserver()

exec sp_addlinkedserver @server = 'yourServerName'
select * from [server].[database].[schema].[table]

and in your example

select * from [yourServerName].[testdb].[dbo].[table]

edited Jul 25, 2012 at 10:13

answered Jul 25, 2012 at 10:06

Dereli

463 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

kombo Over a year ago

Delreli, Now understand that i need to create a linkedserver

Collectives™ on Stack Overflow

how can i read data from db on server to another db on another server

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related