copy table from one db to another

• David Sapp

  SSC Rookie

  Points: 30

  More actions

  June 7, 2006 at 2:48 pm

  #168550

  in sql server 2000, whats the best and easisest way to copy all data from a given table from one db to another db.

  the table is the same name and same fields, just different data in the table.

• peterhe

  SSChampion

  Points: 11469

  More actions

  June 8, 2006 at 7:10 am

  #642512

  There are lots of ways to do this.

  1) use INSERT ... SELECT. 

  If the two DBs are in the same server:

  INSERT NewTable (Field1, Field2,...)

  SELECT Field1,Field2,...

  FROM CurrentDB.Table

  If the two DBs are in the same server, u need to define a linked server.

  2) Use import/export wizard

  3) BCP