Export queries from SSMS to files - not the results but the query

I want to export all my queries as individual files for purposes of putting them into mercurial source control, but I don't know how to export the individual queries as individual files without having to open each one, then save to the folder, then add into the project, or some equally convoluted process.

I开发者_运维百科 wouldn't mind having to add each one individually, but how do I get them out of the database as individual files without opening them all and doing each one save as? Ostensibly I would like them named with the name they have in the database right now.

I could easily dump the whole lot into one long file using database tasks, but that's not really super helpful is it?

I have SSMS 2k5 and 2k8 (and VS 2k5, 2k8, 2010 to boot) to work with, any thoughts?

Right click on the database. Select Generate Script. On the last page. Script To file you can choose single file or file per object

When you script a database in SSMS you have the option of one file per objects.

SMO is useful with a small app to iterate through

Third party tools like Red Gate SQL Compare (there are other free tools) can script too

I would write a small C# program which extracts your database object via SMO and stores them in your filesystem the way you want.

It is rather easy to write stored procedures which fetches the definition into the result as text. sp_helptext could be used as start. Than you can use PowerShell to write the Output to the file system.

It sounds as if this would fit rather good into the Really Simple Data Dictionary codeplex project. link text