Sunday, January 18, 2015

Backup a table with schema and data in SQL Server



Right click to database name >> Tasks >> Generate Scripts …
Choose table you want to backup >> Next

Click Advanced

At  General category >> Types of data to script: schema and data >> OK
Rename your script file >> Next
Next
Finish
Open script file, the result as:

0 comments:

Post a Comment