Execution time running script in Query Analyzer vs. OSQL

kristofferkristoffer Posts: 2
edited December 13, 2005 5:39AM in SQL Compare Previous Versions
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?
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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!
    · Share on Twitter
This discussion has been closed.