On SQL Server Management Studio v 19.1 on database TEST I have more than 1000 tables, views and stored procedures.
I want to export the definitions and import them into database PROD.
Due to the large number of objects it is impossible to use “Generate scripts”
And I do not have access to all the SYS tables.
New contributor
PerGew is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.