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

Deploy objects to script folder without Schema as prefix

Is there a way to deploy objects to Visual Studio's DB Project script folders without having the schema name as the prefix. We have our schema's set up as folders so that all objects within a schema are underneath that folder. The schema name is not needed in the name of the file this way and objects can be searched quickly.
for example:
DBProjectNamedboStored Proceduresdbo.MyProcedureName.sql -> MyProcedureName.sql
DBProjectNameerrorStored Procedureserror.MyErrorProcedureName.sql -> MyErrorProcedureName.sql

If this is not possible now, please add this as an enhancement.
Sincerely,
Jeff Cantwell
jcantwell
0

Comments

1 comment

Sort by
  • mattchandler
    Hi Jeff,

    Thanks for your feedback. When deploying to scripts folders we would not normally rename files to add the schema part onto the filename, but I can see this would not help when we are adding new objects into the schema. Aside from manually renaming files I'm afraid I can't think of any good way to generate files in this format with SQL Compare at the moment.

    Matthew Chandler
    Software Developer on SQL Compare and SQL Data Compare
    mattchandler
    0

Add comment

Please sign in to leave a comment.