Transfer data from 2 DB Diff

• thtsps

  SSC Veteran

  Points: 226

  More actions

  November 20, 2007 at 9:30 pm

  #176923

  I have 2 database the name are 1DB,2DB and i need transfer some data from field of table 1DB to some field of table 2DB How can i do ?. As i did it i used import data and doesn't match what i need. Thanks in advance.

• Grant Fritchey

  SSC Guru

  Points: 398916

  More actions

  November 21, 2007 at 4:58 am

  #753039

  Assuming both databases are on the same server:

  INSERT INTO DB1.schema.table

  ()

  SELECT ...

  FROM DB2.schema.table

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning