Generating individual deploy scripts for each table in a DB?

jstemper · March 20, 2020 7:34PM

Part of our internal procedures is to log each DDL change with a script file in addition to deploying the changes.
Is there a setting/way to to generate a separate script for each entity (table) rather than the one big script?

David Atkinson · March 20, 2020 7:39PM

@jstemper - you can create a scripts folder from a database. Is this what you are looking for?

jstemper · March 20, 2020 7:49PM

This is not available in the Standard edition is it??

David Atkinson · March 20, 2020 8:10PM

jstemper said:

This is not available in the Standard edition is it??

It's only available in the Pro edition. Have you considered SQL Source Control? This tool is designed to manage your DDL creation scripts in version control.

jstemper · March 20, 2020 8:11PM

Trying to do it with tools I've already licensed. Thanks

David Atkinson · March 20, 2020 8:25PM

If you want basic functionality, then you can use SSMS for this. Right click on a database, go to Tasks then Generate Scripts.

Generating individual deploy scripts for each table in a DB?

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk