Options
scriptfile generation to syncronize db from scripts folder
rchan
Posts: 11
I am using the command line and the argument /scriptfile to create a single generated script.
Is it possible to generate multiple script files instead of one long concatenated set of differences?
I work at a company where we deploy to the production database with a set of changed scripts -- e.g. lets say there are 100 stored procedures. During a bug fix, we modify 3 of the stored procedures.
The developers give the 3 scripts the DBA to execute in the production environment.
What we are trying to accomplish is to automate our deployment package so that a developer doesn't have to manually select the 3 scripts that are different for inclusion into a build package.
Thoughts?
Thank you.
Is it possible to generate multiple script files instead of one long concatenated set of differences?
I work at a company where we deploy to the production database with a set of changed scripts -- e.g. lets say there are 100 stored procedures. During a bug fix, we modify 3 of the stored procedures.
The developers give the 3 scripts the DBA to execute in the production environment.
What we are trying to accomplish is to automate our deployment package so that a developer doesn't have to manually select the 3 scripts that are different for inclusion into a build package.
Thoughts?
Thank you.
Comments
I'm not certain exactly what you are attempting to do - what should the contents of each of the script files be? Could you achieve the result that you want by selecting just the objects that you want in a particular script before generating the synchronization script (using the /include or /exclude command line options)?
Redgate Software
For example, developers do not control (or own) user roles and permissions on objects. It would be nice, for example, if when doing script - db synchronization, that all the users/roles/permissions could be scripted in its own files, while each stored procedure difference be scripted in its own file, etc.
But yes, it looks like I will have to use SQL Compare to generate a list of differences, and then use my own scripting tools to copy the scripts to form my own deployment package to install on the database. Thanks.