Generate Script all objects of database

[sneevand]

• SQL Operations Studio Version:0.25.4

Steps to Reproduce:Feature Where can i find ability to generate script all objects of Database; Only schema , only data or schema+data, Include Primary Keys, Index etc.

--Ability to copy the server name from the existing connection.

[kburtram]

We don't currently have support for scripting all objects at this time. We have discussed this and will add the suggestion to the backlog for consideration in the future release.

Currently, we recommend giving mssql-scripter command-line tool a try for this scenario (please see https://blogs.technet.microsoft.com/dataplatforminsider/2017/05/17/try-new-sql-server-command-line-tools-to-generate-t-sql-scripts-and-monitor-dynamic-management-views/ for details). If mssql-scripter is installed you can execute using the integrated terminal to accomplish what you want inside SQL Ops Studio, albeit without a nice integrated UI.

[joshbooker]

Here is a suggestion and test repo for a superset of this request. Please vote. https://github.com/Microsoft/sqlopsstudio/issues/389