Friday, December 16, 2011

How to Script Data from a Table ..?

Most of the time we need to script data of a table which holds configuration Values or Date Dimension Tables for later use....obvious that its a waste of space to take a entire database backup !....SQL Server provides a functionality to export table data (Insert Values script) to a .SQL file...
Here is a Step by Step Guide to do the same..

Step 1 : Go to Tasks -->Generate Scripts

Step 2 : Click on Advanced -->Types of Data to Script-->Select Data only

Save the file in the required Location and open it in SSMS and you can view the insert scripts !!!

Will be back with more posts !! bye bye for now :) ...