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

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

VM_SQLVM_SQL Posts: 5 New member
edited February 25, 2021 10:11PM in SQL Compare
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

Answers

Sign In or Register to comment.