What are the challenges you face when working across database platforms? Take the survey
Options

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?

Comments

  • Options
    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!
This discussion has been closed.