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

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

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
VM_SQL
0

Comments

3 comments

Sort by
  • 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?
    DanC
    0
  • 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.
    VM_SQL
    0
  • 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

    DanC
    0

Add comment

Please sign in to leave a comment.