How can I export tables to SQL Script?

Question

I need to export many tables to Script SQL.

I'm using Microsoft SQL Server 2014.

How can I do this?

Can you please clarify? Do you need to export table names, schema, creation scripts, data.... — S3S
– S3S, Commented Jun 17, 2016 at 16:02
stackoverflow.com/questions/20542819/… This should be marked duplicate — Sam
– Sam, Commented Jun 17, 2016 at 16:02

mvisser · Accepted Answer · 2016-06-17 16:15:38Z

2

1) Right click on the database

2) Go to Tasks -> Generate Scripts

3) A Generate and Publish script popup window will appear. Click Next

4) Select specific database objects. And select Tables

5) Go To Adanced, another popup window will be displayed. Scroll down to Types of data script and select Schema and Data

6) And then Save to file or clipboard and click Next

answered Jun 17, 2016 at 16:03

mvisser

6705 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

I need to export DDL and Data. This export only the DDL.

Nazir Ullah · Accepted Answer · 2016-06-17 16:13:02Z

1

1) Simple Right Click on Database name in object explorer,

2) menu list will be open then from this list go to Task in Task sub menu Click on Generate Script

3) A New Dailog will be opened click on Next button

4) select the tables and any DDL name which you want then click next

5) Then choose path where you save script click next

answered Jun 17, 2016 at 16:07

Nazir Ullah

6105 silver badges13 bronze badges