Sergey Metlov Sergey Metlov - 1 year ago 143
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

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

How can I do it using Management Studio?

Answer Source

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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download