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

    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
    Lexington, KY
    If they are on the same database server you can do this:
    INSERT INTO somedatabase..sometable ( SELECT FROM currenttable )
    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:


  3. #3
    Join Date
    Oct 2001
    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.

    Content Manager Webmasters Resources 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