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
1 comment
-
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!
Add comment
Please sign in to leave a comment.