Wednesday, August 30, 2006

Executing SQL Scripts ?

 

Most of the deverlopers has this question, how to create the dev database using a wizard, I bevelie the easyest way out is to use the osql,

execute this in the command prompt.

osql /S (local) /U sa /O sa /i C:\script.sql

 

And I found this intersting artical about how to handle SQL failover functionalities with .NET,

 

http://www.doingitwith.net/2006/08/getting-warmer-...

No comments: