What are the challenges you face when working across database platforms? Take the survey

Separate Scripts for each object in deployment scripts

Is it possible to generate separate scripts for each object for deployment, as the generate script creates one large script with all the changes in one file.


Best Answers


  • Options
    Hi DenisJCilliers,

    After a fashion yes. If instead of deploying to a db, you deploy to a scripts folder, multiple scripts will be generated, one for each db object.

    For more details, please see here.
    Kind regards
    Peter Laws | Redgate Software
    Have you visited our Help Center?
  • Options
    DenisJCilliersDenisJCilliers Posts: 23 New member
    There is one flaw with this approach in that it would deploy the full database and not the difference between databases.  I was looking to create the deployment script that is generated from one database to another as separate scripts.
Sign In or Register to comment.