Deploy objects to script folder without Schema as prefix

jcantwell

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

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