In SQL, if you don’t define a default schema, it defaults to ‘dbo’, so in this case that would solve the issue from their side very well. In fact, everything should default to ‘dbo ...

Schemas in SQL 2005 are created without tying them to user accounts, which builds a separation between security and schema management. Available permissions have been greatly expanded.

We're going to run this through the paces as I like the idea of free--especially at the cost of Red Gate SQL compare per developer. Even if we only use VS 2013 Express for SQL schema and data ...

tl;dr - see last paragraph. trying to design a generic file attachment table(s) for some business objects we keep in sql 2008 r2. files will be stored on disk and i'm not really interested in ...

The newly introduced schema synchronization wizard supports Oracle, Microsoft SQL Server, DB2 LUW and Sybase ASE.

Idera's SQL comparison toolset provides a complete comparison and synchronization solution in a single product, and helps DBAs to compare databases, including schema objects and data; display the ...