Stop putting schema name in filename
ccfs
Posts: 3 New member
in SQL Compare
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.
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.
Tagged:
Best Answer
-
Tianjiao_Li
Posts: 684 Rose Gold 5
It's not possible name the file without schema for SQL Compare unfortunately. Please can you leave your suggestion on user voice forum?
Thanks.
