How to copy a selection of data accross servers?

• achatzianastassiou

  Grasshopper

  Points: 17

  More actions

  February 23, 2010 at 4:11 am

  #211548

  Hi all,

  I am quite new to SQL databases.

  I need some guidance as to what are the ways to move a selection of data from server A to server B, if the servers are able to see each other and communcate.

  The selection of data will have to be written in a table in server B.

  Thanks in advance.

• Chandra Sekhara Vyas Dhara

  SSChampion

  Points: 10207

  More actions

  February 23, 2010 at 4:14 am

  #1123524

  You can use linked server. Read BOL for further information

• Prakash Shetty

  SSC Enthusiast

  Points: 113

  More actions

  February 23, 2010 at 4:46 am

  #1123537

  Hi,

  The simple way will be to use SQL server import export wizard.

  Right click on your database select TASKS then IMPORT DATA or EXPORT DATA which ever is suitable

  and you can transfer the required data easily.