Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-06-17 : 08:04:58
|
| Sean T. Warner writes "I am looking for performace commparisons of using ISQL command line vs. DTS. Currently I am using a shell command from within VB to extract the Data to an ascii file via the following command:\\<<ServerNameHere>>\Program Files\Microsoft SQL Server\80\Tools\Binn\isql.exe" -Q"exec cp_rpt_Earnings null, null, 1" -o"\\<<ServerNameHere>>\FormTrap\FT_Files\Data files\Earnings.dat" -w 9999 -s"|" -S<<ServerName>> -U<<UserName>> -P<<PW>>The format and contents are controlled within the call to the SQL Proc: "cp_rpt_Earnings null, null, 1" How efficient is ISQL? I assume the overhead is minimal. It works great, and I avoid the alternative of writting the Ascii file from within VB via a recordset.But how does it compare to DTS? I assume the options with DTS will cause much more overhead.Please advise, Thanks,Sean T. WarnerSeanTWarner@Yahoo.com" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-06-17 : 08:07:32
|
| Why not use bcp (you mentioned it in the title)? If you're generating text files of the results, isql is not really the best tool for that. DTS and bcp are better suited. In my experience bcp has been faster than DTS but unless you're outputting 20,000+ rows, or have a relatively slow SQL Server, you probably won't see much difference. Same applies to isql, but again it's not really a data export program. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-06-23 : 12:48:26
|
| bcp...bcp...bcp...bcpAnd it's reccommended to use osql now...Brett8-) |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-06-23 : 13:43:57
|
| bcp will be fastest and probably simplest.I usually call an SP. The SP creates a global temp table (with a single column + an id) and that gets bcp'd out.It makes it easy to develop as you have the table to look at and don't have to chase files.Putting the functionality into a client app like VB or dts usually just adds unnecessary complexity.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
|
|
ISQL vs. DTS (vs. BCP)