How to extract data and schema from a Table using MS Sql Server Management Studio.
Version of SQL Server Management Studio : 11.0.2100
|
|
1. Go to your database and right click on it.
2. Select Tasks > Generate Scripts
3. It will open up the following window.
|
|
4. Click on Next button which will open Choose Objects window.
5. Select the tables you want to back up and click on "Next" button.
|
|
6. Set the scripts options by specifying the folders where you want the sql
script to be saved.
7. Click on "Advanced" button
|
|
8. In the Advanced Scripting Options window, corresponding to Types of data to script
select the option of "Schema and data" and then click "OK" button.
|
|
9. Click "Next" and then "Finish".
Hope this helps :)
|
No comments:
Post a Comment