How can we help you today? How can we help you today?

Execution time running script in Query Analyzer vs. OSQL

Running SQL Compare-generated scripts in Query Analyzer is fast. Running them with OSQL is very slow, however. Do you know why, and how I can improve the execution time?
kristoffer
0

Comments

1 comment

  • Brian Donahue
    Hello Kristoffer,

    If I remember correctly, ISQL /w (Query Analyzer) works better because it executes SQL in batches (separated by the GO command). I'd imagine that scripting with SQL Compare using the 'do not include transactional plumbing' option could possibly speed things up. You'd lose the rollback on error capabilities, though!
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.