how to mapping data or transfering data from one server to another server here i am using sql 2008 r2?

• Sivaganesh Tamilvendhan

  Hall of Fame

  Points: 3498

  More actions

  July 7, 2012 at 1:19 am

  #258566

  here i am having membertable with 5 column with 500 data s in one server1

  and now i want to transfer data only to another server2 which is having member table

• ksrikanth77

  SSCrazy

  Points: 2232

  More actions

  July 7, 2012 at 8:57 am

  #1509976

  There are many ways to trnasfer the data,

  1. Use insert into Server2.dbname.schemaname.member

  select * from Server1.dbname.schemaname.member

  2 use SSIS import data import

  3 use the merge statement to update the data.

  Regards

  S.R.Kundur

• Igor Micev

  SSC-Dedicated

  Points: 33109

  More actions

  July 8, 2012 at 5:26 am

  #1510078

  There are may ways, but so practical and easy one is by using ssms:

  right click -> Tasks ->

  - Copy Database...

  - Import Data...

  - Export Data...

  Regards

  IgorMi

  Igor Micev,My blog: www.igormicev.com

• Ravi SQL

  SSCommitted

  Points: 1714

  More actions

  July 8, 2012 at 11:38 pm

  #1510167

  Hi,

  Create a linked server with "SomeLinkedServerName" on the Source SQL Server instance.

  and execute the below statement (on the same instance):

  INSERT INTO SomeLinkedServerName.DatabaseName.SchemaName.TableName

  SELECT * FROM SchemaName.TableName

  Regards,
  Ravi.