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

Deploy objects to script folder without Schema as prefix

jcantwelljcantwell Posts: 2 New member
edited September 21, 2016 7:11AM in SQL Compare
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

Comments

  • Options
    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
    Matthew Chandler
    Software Developer on SQL Compare and SQL Data Compare
Sign In or Register to comment.