Results 1 to 4 of 4

Thread: Copy table to another server

  1. #1
    Join Date
    Sep 2006
    Location
    Craiova, Romania
    Posts
    6

    Copy table to another server

    Hi all,

    Does anyone know if there is possible to copy table from a DB in server 1 to a DB in server 2, just like in Import/Export Wizzard but through a script job? Server 2 is "hot" and I am not allowed to use BCP to execut a job locally on Server 2 to import data, but only to export data from Server 2 to Server 1.
    I need to know what is the instrument that could do this job.

    Thanks in advance.
    74SYL

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Create linked server and you can copy table with 'inster ... select ... from ...' via linked server.

  3. #3
    Join Date
    Sep 2006
    Location
    Craiova, Romania
    Posts
    6
    Thanks for idea, rmiao. I already tried in this way but "insert ..." creates logs on Server 2 and this is unacceptable. I just need to schedule Import/Export Wizzard to copy a table from Server 1 to Server 2 at a specified time. Or to put in a script job what the Wizzard actually does.
    Because Import/Export Wizzard is the only way which doesn't affect Server 2, according to my observations (or maybe is there other way?).

  4. #4
    Join Date
    Sep 2006
    Location
    Craiova, Romania
    Posts
    6
    All this time the solution was under my nose. SSIS pakage can do the required job. It works great!
    Thanks again rmiao!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •