Sergey Metlov Sergey Metlov - 1 month ago 17
SQL Question

Script all data from SQL Server database

I have two databases with equivalent structure and I need to extract data from one of them in form of

INSERT
statements (generate script to apply it on the other database).

How can I do it using Management Studio?

Answer

You could use the free SSMS Toolpack add-in for SQL Server Management Studio.

See the section on Generate Insert statements from resultsets, tables or database

Update: OK, for SSMS Toolpack in SSMS 2012, a licensing scheme has been introduced. SSMS Toolpack for earlier versions of SSMS are however still free.