How can we help you today? How can we help you today?

Generating individual deploy scripts for each table in a DB?

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?

jstemper
0

Comments

5 comments

Sort by
  • David Atkinson
    @jstemper - you can create a scripts folder from a database. Is this what you are looking for?

    David Atkinson
    0
  • jstemper
    This is not available in the Standard edition is it??
    jstemper
    0
  • David Atkinson
    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.
    David Atkinson
    0
  • jstemper
    Trying to do it with tools I've already licensed.  Thanks
    jstemper
    0
  • David Atkinson
    If you want basic functionality, then you can use SSMS for this. Right click on a database, go to Tasks then Generate Scripts.
    David Atkinson
    0

Add comment

Please sign in to leave a comment.