Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2001
    Posts
    2

    Unanswered: any better option than BCP

    I have to write a program for data migration between two sybase databases. BCP is very slow. Can U suggest something better.

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    If they are on the same database server you can do this:
    INSERT INTO somedatabase..sometable ( SELECT FROM currenttable )
    or
    INSERT INTO sometable ( SELECT FROM someotherdb..oldtable )

    If they are on different boxes you could set up replication (if you have rep server) I suppose and transfer that way.

    Or you could use CIS and set up a proxy table (never tried it so this could be wrong ) on one box and simply insert into it.

    Check out the manuals and other links in this thread:
    http://dbforums.com/t65148.html
    Thanks,

    Matt

  3. #3
    Join Date
    Oct 2001
    Posts
    10
    Just drop the indexes on the table that you are loading. BCP will then go into "fast bcp" mode and it should build much quicker.

    Then just rebuild the indexes. If you have a clustered index, use the "with sorted data" option.

    Frank
    Content Manager Webmasters Resources
    www.serverexpert.com/ Help with servers and the software that they run.

Posting Permissions

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