How to insert data to database in another server?

Question

I am using Sql Server 2005.
There are two different Sql Servers.
I need to get data from one server and insert them into database on other server.
As a example assume there is two servers call A and B.
A has DB call ADB and B has DB call BDB.
I need to get data from ADB and insert them into BDB.

Any suggestion?

Joe G Joseph · Accepted Answer · 2012-09-06 06:13:18Z

1

You could do it many ways..

If both servers are in the same network use COPY DATABASE option in SSMS

COPY Databade

IF both servers are not in the same network, then you could generate script from one database and execute in another

a detailed example is here

Another option is to take backup of the database and restore it in the other server, which will be very simple and effective if the data is huge

answered Sep 6, 2012 at 6:13

Joe G Joseph

24.2k5 gold badges58 silver badges58 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 10:24:41Z

0

On Server A add a linked server (B)

http://msdn.microsoft.com/en-us/library/ms188279.aspx

Then you can transfer data between the two.

Export table data from one SQL Server to another

HTH

edited May 23, 2017 at 10:24

CommunityBot

11 silver badge

answered Sep 6, 2012 at 7:24

Fred

5,8684 gold badges47 silver badges76 bronze badges

Collectives™ on Stack Overflow

How to insert data to database in another server?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related