Adding new Stored Proc/View/Function to SQL project folder avoid adding Schema name in SQL FIle

VM_SQL

Adding new Stored Proc/View/Function to SQL project avoid adding Schema name in SQL File to Project folder-

When deployed scripts from DB to Project Folder using SQL Compare

DB File name with SQL schema - UI.spGetFormData 

Add in Project folder with Schema Name - UI.spGetFormData  --Note- path of folder is given UI\Stored Procedures\


Want to store file without schema name UI.spGetFormData in project folder as below- 

Add in Project folder with Schema Name - spGetFormData  --Note- path of folder is given UI\Stored Procedures\spGetFormaData


When object is modified  then it doesn't add schema to project folder using SQL Compare tool

Is there any project setting which can help here

DanC

Hi @VM_SQL

Could I clarify with you, are you wanting the project folder to have the structure of schema name\object type\filename so dbo\View\TestView

Or simply have it so objects don't have the schema name prepended to the filename?

VM_SQL

I already have folder with schema name\object type\filename so dbo\View\TestView

but when for new objects pushed to my project folder when doing SQL compare  - it created file in this way dbo\View\dbo.Test2View . I don't need 'dbo'schema name in file name.

DanC

HI @VM_SQL

My mistake! I double-checked with the developers and there's currently no option for this and it would be regarded as a feature request. 

I would advise posting the idea here for other users to vote on: https://redgate.uservoice.com/forums/141379-sql-compare