Results 1 to 4 of 4

Thread: export question

  1. #1
    Join Date
    Aug 2002
    Posts
    14

    Unanswered: export question

    how can I call export with more than one table ,
    I saw that I can give the exp utility and bcp utility only one
    table each time .
    if it can not be done by the utilities (exp , bcp) ,can you please give a script that does it.

    10x in advance

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    Paul Young
    (Knowledge is power! Get some!)

  3. #3
    Join Date
    Feb 2002
    Posts
    2,232
    What is your eventual goal with the exported table - are you going to import into another sql server instance ?

  4. #4
    Join Date
    Aug 2002
    Posts
    14
    Originally posted by rnealejr
    What is your eventual goal with the exported table - are you going to import into another sql server instance ?
    I want to keep the export file on disk and import it into the same database or diffrent database.

Posting Permissions

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