best practice for automatically "copying" a table to another server

• Burt Jacobs

  SSC Journeyman

  Points: 79

  More actions

  October 25, 2004 at 2:27 pm

  #162532

  Hi,

  I have an EntMan job that runs on server X at 2:00am, and creates table Z.

  I want to add a new job step that will take that table Z and "move/copy/dump/whatever" it to Server Y (db same name as on server X).

  Is that doable?

  Any help will be greatly appreciated.

  Thanks in advance.

  Burt

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  October 26, 2004 at 9:54 am

  #528012

  If you have a linked server, then it's pretty simple. Same process, just include the server and database name wiht the owner and table name.

  Otherwise, DTS might be the best solution beyond that.