Export Table Schema & Data in SQL Server - thoriqaziz.com

thoriqaziz.com

Do your hobby

Export Table Schema & Data in SQL Server

Share This
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.

No comments:

Post a Comment

Pages