Geek Answers Handbook

Search for an application that generates INSERT statements for data in tables (tables)

Looking for an application that allows me to connect to SQL Server, select any number of tables and then generate INSERT statements for the data contained in these tables.

Does anyone know about such an application? It is preferable that free, but commercial versions could be interesting.

Thanks Bruce

+4
source share
4 answers

Here's an interesting SPROC that seems to do what you want.

+3
source

You can take a look at the Microsoft SQL Server Database Publishing Wizard 1.1 ( http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en ). From the description:

The SQL Server Database Publishing Wizard enables you to deploy SQL Server databases in a hosting environment on SQL Server 2000 or 2005. It generates a single SQL script file that can be used to recreate a database (both schema and data) in a shared hosting environment. where the only way to connect to the server is through the web control panel with a script execution window.

+2
source

Try the SSMS Tools Pack . It is free and has many other enhancements for Sql Server Management Studio.

+1
source

EMS DB Extract for SQL Server is commercial, and you will need to check your site for evaluation, create SQL scripts with INSERT data statements from selected tables.

Of course, the software will do much more, but it will also do what you want.

0
source

More articles:


All Articles