Exporting Data (Not Just Schema) from SQL Server

I’m posting this here because I always have trouble finding it when I need it.

SQL Server 2005 ships by default with a utility for exporting objects to T-SQL scripts. Unfortunately, it doesn’t allow you to export the data in your tables.

Revolutionize Your Business With Generative AI

From product design and software development to virtual agents, content creation, and reporting, GenAI is transforming business. Our AI experts help you unlock GenAI’s full potential and drive growth.

Let’s Get Started

There is, however, a freely available add-on that does this for you – it works just like the wizard that’s included out of the box, but the last step asks you if you want schema and data, data only or schema only.

You can get the "Microsoft SQL Server Database Publishing Wizard 1.1" here:

http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en

In order for it to install properly, you will probably also need the "Feature Pack for Microsoft SQL Server 2005 – April 2006" which you can get here:

http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&displaylang=en