How to insert data from one database to another

• mdmandar

  SSC Veteran

  Points: 222

  More actions

  February 21, 2003 at 12:17 am

  #80314

  I have two database on the smae server

  i wanted to select datat from one and insert into another

  But my insert into statement returns error

  Can some one guide me.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  February 21, 2003 at 3:32 am

  #449463

  INSERT db1.objectowner.tblname (collist)

  SELECT relativecollist FROM db2.objectowner.othertblname

  If you follow that format and get an error then we need to know the error to help further.