Using temp tables with linked server?

• susy-1061416

  Newbie

  Points: 9

  More actions

  June 19, 2009 at 3:57 am

  #206160

  Hi, I need a suggestion of the professionals in sql server.

  I need to make an script to data migración between diferents sql server db; change of new structure data and I using linked server and temp tables, but I'm not sure this is the best way

  to do it, first because I don't know if is a good practice keep a lot of infomation

  in a temp table.

  Thanks for your help,

  susy

• Randy-574768

  Ten Centuries

  Points: 1385

  More actions

  June 19, 2009 at 8:29 am

  #1012431

  What do the updates you're performing look like? How many records, usually?

  Randy