0

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?

Himanshu
  • 31,810
  • 31
  • 111
  • 133
user1650955
  • 1
  • 1

2 Answers2

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

Joe G Joseph
  • 23,518
  • 5
  • 56
  • 58
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

Community
  • 1
  • 1
Fred
  • 5,663
  • 4
  • 45
  • 74