Wednesday, September 19, 2012

MS SQL 2008 R2: Export table data to SQL file

1. Right click on the DB
2. Select Task >> Generate Scripts
3. In Choose Object section, select specific database objects
4. Select your tables
5. Next, in Set Scripting Options, click Advanced button >> Types of data to script >> select Data only

For old versions of MS SQL, using Sql Server Management Studio 2008 R2 to connect & export data
Subscribe to RSS Feed Follow me on Twitter!