var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.
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:
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.