Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003

    Unanswered: Backup and Load Data Only

    I'm moving a production database onto a new server and I don't want to use the same devices allocation from the old server because I have different hardware in the new server and need to take advantage of it.

    I've created the new devices and I have the database schema in place ready for the data transfer.

    What is the easiest way to move only data over to the new server. I'm working with more than 100 tables and I'm not sure that bcp is the best process.

    Any help or ideas would be great.


  2. #2
    Join Date
    Jan 2003
    France - Nancy

    with a dump/load you can't choose to load just the data (like you can do with Oracle).
    The best solution is bcp.

Posting Permissions

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