0

I need to export SQL Server 2017 database; can anyone please help me where I can find this?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Nikul Panchal
  • 663
  • 1
  • 14
  • 32
  • I need to export data structure of database, i am not able to find where i can do that – Nikul Panchal Feb 22 '18 at 05:30
  • Possible duplicate of [How can i get sql query script by table name in sql server](https://stackoverflow.com/questions/48905253/how-can-i-get-sql-query-script-by-table-name-in-sql-server) – SMor Feb 22 '18 at 12:49

1 Answers1

2

Right click on a database ► Tasks ► Generate Scripts...
Select Script entire database and all database objects. Next like there is no tomorrow.
If you would like to include data as well, on the second step there is Advanced button. Find Types of data to script, then you can include data to schema as well. But there are more efficient ways to copy data exist.

enter image description here

cassandrad
  • 3,412
  • 26
  • 50