What is the best way for deploying sql scripts apart form using SqlCmd via power shell script ?
Nabeel
I would use somekind of migrations framework so you can put you migrations in source control and have full controll over it. I have a sample of it using migratordotnet here: https://github.com/mastoj/OctopusDeployDemo.