Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008
    Posts
    18

    Unanswered: some questions about Sybase BCP

    I need to migrate a Sybase db (ASE 15.0.2) to a new Sybase server (ASE 15.0.3) :

    1. I know Sybase has bcp, but does Sybase also have a utility program similar to MS SQL Server DTS ?
    2. Will bcp fire the triggers of the destination server tables ?

  2. #2
    Join Date
    Oct 2007
    Posts
    4
    1. No, there isn't a Sybase equivilent for DTS.
    2. Triggers are not fired via bcp - but note that bcping into tables with triggers or indexes can result in big log files. If you are bcping a huge number of rows, dropping triggers and indexes first is advised.

    Hope this helps,
    Al

  3. #3
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    2) You could always first bcp into a table that has no indexes (a transfer table). Then you could insert the data from here into your main table which would then call the triggers you have set up.

Posting Permissions

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