How to convert sql file to executable file

You can not convert an sql script to executable. This is clear nonsense.
Still, your requirement itself makes sense.
First of all, you can concatenate the scripts, thus you can get a single one.
You can also use sqlcmd utility[^] to execute the scripts. So you can simply create a batch or vbs script that scans a folder for files with sql extension for example and executes them one by one. Or you can use even powershell for that.

Of course, you could convert your sql files to resources, and embed them into an executable that is will execute them against the sql server and the database[^]. But you have to consider if you really need this. It depends on how experienced users will use this at the end for example. If the client could live with executing scripts one by one, a simple batch script would be also a huge leap, but for users without any SYSDBA experience I would make this executable. But again: it is not a "conversion". You need to make one for your own purposes.

Hi,
what ever i understood by your statement you can achieve your goal in following way...
you can generated script for that.

1) just Right click on your database.
2)go to task
3) select "Generate Scripts"
4) follow the steps as per instructions given on the screen.
and there you go..

for details go through the below link..


http://blog.sqlauthority.com/2011/05/07/sql-server-2008-2008-r2-create-script-to-copy-database-schema-and-all-the-objects-data-schema-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/[^]