Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2008
    Posts
    4

    Unanswered: importing into databases

    Hi. I need to create a bunch of databases then import the data from old databases into them. I know how to do it with the GUI. Is there a way to do it with SQL statements or from the command line? I need to script it so I'm looking for an alternative to the GUI.

    Thanks.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    You can use the BCP utility to transfer data. This is a commandline utility.

    Alternatively, you can use the import/export wizard, and save the resultant DTS package, but it is a pain to modify later on.

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Where are the databases?
    Which GUI? You may be able to save the operation of the GUI wizard as a package.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Jun 2008
    Posts
    4
    How about a direct SQL 2000 to SQL 2005 import. Is there a command line tool or SQL commands to do that?

  5. #5
    Join Date
    Sep 2005
    Posts
    161
    If you are just wanting a copy your database from 2000 to 2005, you can detach the database file on the 2000 server, and then attach it on the 2005 server. It will upgrade the file when you attach.

  6. #6
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    I prefer backing up and restoring, myself. The detach re-attach route doesn't give you enough in the way of back out options.

Posting Permissions

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