View Single Post

   
  #1 (permalink)  
Old 04-12-2008, 01:05 AM
Matt McLeod
 
Posts: n/a
Default ASE Replicator and bcp

I'm kinda new to this DBA lark, so this may seem like a stupid question,
but the ASE Replicator docco for 12.5.4 doesn't say anything one way or
the other.

I've been asked to replicate a database from one machine to another.
Replication Server isn't an option, so I'm looking at ASE Replicator.
I think the performance will probably be adequate.

However. First thing every day a bcp is done into this database. I had
understood that having bulkcopy enabled on a database basically screws up
transaction-log dumps. The database also has "trunc on checkpoint" enabled
though I could probably get that removed.

Is this bcp going to make Replicator unsuitable?

Thanks.

Matt

--
* Matt McLeod | mail: matt@boggle.org | blog: http://abortrephrase.com/ *
--- People can do the work, so machines have time to think ---
Reply With Quote