<div>
there are some tools like this <br />
i once wrote a script to do it<br />
it needs a little work but you can try it<br />
you just set the table name and run the query<br />
you will get another query as a result<br />
run it and you're done
</div>


there are some tools like this
i once wrote a script to do it
it needs a little work but you can try it
you just set the table name and run the query
you will get another query as a result
run it and you're done

<div>
<a href="http://vyaskn.tripod.com/code/generate_inserts.txt" rel="ugc">http://vyaskn.tripod.com/code/generate_inserts.txt</a>
</div>


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

<div>
<div class="content wysiwyg-content">
Hi,<br />
I am hoping to find a free utility that allows me to select a table form my 2005 db and then extract the data to a .sql file with the complete INSERT statement for each row.<br />
<br />
thanks
</div>
</div>


Hi,
I am hoping to find a free utility that allows me to select a table form my 2005 db and then extract the data to a .sql file with the complete INSERT statement for each row.

thanks

how to extract table data into a script .sql file

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.