SQL drip 38-sql Server 2008 and SQL Server R2 options for exporting data are slightly different

Original: SQL Drip 38-sql Server 2008 and SQL Server R2 options for exporting data are slightly different

Description

previously, to export data from a table as a script, only with stored procedures. A new feature is now added in SQL Server 2008, which supports exporting data from tables to scripts in addition to the definition of the exported table.

Steps:

Right-click the database where you want to export the data, and select the Generate Script option under tasks in the pop-up menu

In the second step select "Advanced Options" if not R2 select " script to write Data" selected to True, here the default is False ,

Yes, R2. Select the type of data to write script to schema and data

(2008R2) is not the same as the following:

SQL drip 38-sql Server 2008 and SQL Server R2 options for exporting data are slightly different