Friday, January 20, 2017

Visual Studio copy dll from project folder to bin folder on build solution

If we want to copy from project folder DLL (3rd party or other type)  to Bin folder during build the solution we can easily map that option.

right click on you solution -> Properties -> Buld Events and follow the format for your folder

 C:\Windows\System32\xcopy /d /y "$(ProjectDir)PackagedDLL\FAX\*.*" "$(TargetDir)"  

In my case FAX is my folder name.

SQL Get all Index create script from Database

To get all script from database as a create new index into another database you can use the following --Get all Index Script SELECT...