Are There Any Free Tools to Generate 'Insert Into' Scripts in Ms SQL Server

Are there any free tools to generate 'INSERT INTO' scripts in MS SQL Server?

This web site has many useful scripts including generating inserts.

You can utilise sp_msforeachtable with it to generate for an entire DB.

Update: There is built-in functionality to script data as INSERTs in SQL Server Management Studio 2008(onwards).

SQL Server 2008:

Right-click on your database in SSMS, select Tasks –> Generate Scripts, ensure your database is highlighted and click next. Scroll down the options list to the “Table/View Options” section, and change “Script Data” to True.

SQL Server 2012:

Right-click on your database in SSMS, select Tasks –> Generate Scripts. Choose the tables you want to generate scripted INSERTs for, then click Next. Choose where you want to send the output to (such as a new Query Window), and then click the Advanced button (which for some reason is in the Save to File Section!). Scroll down the options list to the “Types of data to script” option and change it to either "Data only" or "Schema and data". Click Next twice.

What is the best way to auto-generate INSERT statements for a SQL Server table?

Microsoft should advertise this functionality of SSMS 2008. The feature you are looking for is built into the Generate Script utility, but the functionality is turned off by default and must be enabled when scripting a table.

This is a quick run through to generate the INSERT statements for all of the data in your table, using no scripts or add-ins to SQL Management Studio 2008:

1. Right-click on the database and go to Tasks > Generate Scripts.
2. Select the tables (or objects) that you want to generate the script against.
3. Go to Set scripting options tab and click on the Advanced button.
4. In the General category, go to Type of data to script
5. There are 3 options: Schema Only, Data Only, and Schema and Data. Select the appropriate option and click on OK.
   

You will then get the CREATE TABLE statement and all of the INSERT statements for the data straight out of SSMS.

How can I generate an INSERT script for an existing SQL Server table that includes all stored rows?

Yes, but you'll need to run it at the database level.

Right-click the database in SSMS, select "Tasks", "Generate Scripts...". As you work through, you'll get to a "Scripting Options" section. Click on "Advanced", and in the list that pops up, where it says "Types of data to script", you've got the option to select Data and/or Schema.

Generate insert script for selected records?

If you are using the SQL Management Studio, you can right click your DB name and select
Tasks > Import/Export data and follow the wizard.

one of the steps is called "Specify Table Copy or Query" where there is an option to write a query to specify the data to transfer, so you can simply specify the following query:

select * from [Table] where Fk_CompanyId = 1

Converting Select results into Insert script - SQL Server

SSMS Toolpack (which is FREE as in beer) has a variety of great features - including generating INSERT statements from tables.

Update: for SQL Server Management Studio 2012 (and newer), SSMS Toolpack is no longer free, but requires a modest licensing fee.

How do I generate insert statements with Sql server 2012?

Ah, 2012 ssms tools are no longer free, I had to click on a license and then restart sql server.

---

Related Topics