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

Stop putting schema name in filename

ccfsccfs Posts: 3 New member
We have our database projects in Visual Studio.
VS puts objects in a folder structure of database / schema / objecttype / scriptfile ; so a view in the gold schema would have a path of "MyDatabase/gold/Views/MyView.sql"

If we use RedGate SQL Compare to deploy a new object into the scripts folder, it correctly follows the path, but puts the schema name in the filename, so it would create "MyDatabase/gold/Views/eom.NewView.sql"

Does anyone know if we can stop that behaviour?

We are using SQL Compare V13.7 on Windows 10.0.16299 Enterprise. I found the "Database Project Compatible script folder output" setting in Options made no difference.

Best Answer

Sign In or Register to comment.