Thursday, February 9, 2012

Anyone used ISql tool

Hi
Has anyone used ISql tool that comes with the windows installation. I'm
trying to run an SQL script using it giving the command
iSql -U user -P password -S server -d Database -i <path to sql script file>
What happens is that it does start executing the script but takes so much
time if the script contains around 100-200 statements. When I execute the
same script using MS SqlServer Managment studio, it executes it all within
2-4 seconds. Is there any way to speed up the process using ISql tool, like
if i'm missing any argument or something. Or if there's any alternative
method to do so. Actually I've to do so from my VC++ code so looking for any
alternative method possible.
Regards
UsmanUsman,
I don't know why isql is that slow, but you shouldn't use it anyway.
Isql is only included for backward compatibility. Better use
sqlcmd.exe.
M

No comments:

Post a Comment