Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2008
    Posts
    10

    Unanswered: how to copy from remote to local database (was "please help me out")

    i need to copy database files (in a remote server) to a different location (in local server).Can u please tell me how to write the command for it?

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    So which part of this didn't you get?
    http://www.dbforums.com/showthread.php?t=1633268

    To be more explicit:
    You detach the files.
    You copy and paste the files.
    You attach the files.

    If you have any follow up questions please respond in this thread. Any further threads on this topic will be merged.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Aug 2008
    Posts
    10

    ok thanku

    i know detaching ,attaching but how to copy and paste through SQL commands

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    DOS (xcopy) via xp_cmdshell.

    I would do it manually if I were you though.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    ............or CLR
    Testimonial:
    pootle flump
    ur codings are working excelent.

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'd probably consider a COBOL package on a zOS linked server to launch a Universe PROC that would start a Unix daemon to copy the files from one Windows folder to another. As an alternative, you could also just copy the file manually.

    Just out of curiousity umachaitanyaa, what are you actually trying to do? If you can state what you are trying in clear, ordinary English I strongly suspect that we can help you find a better way to do it.

    -PatP

Posting Permissions

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