So I've run into a somewhat maddening bug (perhaps) with Visual Studio database projects, specifically in 2010 Ultimate.
Basically, let's say I have two .schema.sql files, like so:
File 1
CREATE SCHEMA [Test]
GO
File2
CREATE SCHEMA [AuditTest]
GO
This compiles down and is deployed as:
PRINT N'Creating [AuditTest]...';
GO
CREATE SCHEMA [AuditTest]
AUTHORIZATION [dbo];
GO
PRINT N'Creating [test]...';
GO
CREATE SCHEMA [test]
AUTHORIZATION [dbo];
So it (seemingly arbitrarily) chose to abandon my choice of capitalization.
Why God? Why?!