What is a good, free database scripting tool [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 7 years ago.

开发者_如何学编程 Improve this question

I am looking for a free tool that will allow me to specify a SELECT statement on a table and then generate the result set as a series of INSERT statements to transfer to another database. I have the SQL Publishing Wizard, but that only allows me to generate statements for the entire table, and I can't specify a WHERE clause to filter the data it publishes. So far the only tool I have seen is made by Red Gate, which my employer only gives to DBA's. Are there any free tools out there that will let me do the same thing, without having to go and bug a DBA everytime I need to update some data in a database?

---

SSMS Tools Pack has a good collection of features, including generating insert statements. Works on MS SQL 2005 and beyond.

---

I've used this one in the past, I don't think its been updated recently:

http://vyaskn.tripod.com/code/generate_inserts.txt