Following are the steps for exporting your database and data view script generation.
- Right click on the database that you would like to export
- Go to Tasks > Generate Scripts...
- A screen will pop up. Your database should be selected in the list.
- Click Next
- Change the following settings
- General
- ANSI Padding = False
- Include Descriptive Headers = False
- Script Extended Properties = False
- Table/View Options
- Script Data = True
- Click Next
- Choose the Tables checkbox and click next
- Click the Select All button and click Finish
- Click Finish again and your script should be in a new query window.
No comments:
Post a Comment