Monday, January 9, 2017

Export Table Schema & Data in SQL Server

Categories:

This is steps how to export table schema including data in SQL Server 2014.

  1. Open SQL Management Studio then connect to your server name.
  2. Right click of database of table that you want to export > Tasks > Generate Scripts..
  3. At the Generate and Publish Script window, click Next, then you can select to the table you want to export by choose Select specific database object and checklist the table.

  4. Click Next. You can rename the name of script by change it in File name field. Then click Advanced option, scroll down until find Types of data script. Change the value to Schema and Data and OK.
  5. Click Next > Next (prosess will appear) > Finish.

Spread The Love, Share Our Article

Related Posts

No Response to "Export Table Schema & Data in SQL Server"

Post a Comment