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
Hint:
For old versions of MS SQL, using Sql Server Management Studio 2008 R2 to connect & export data
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment