U4-11413 - Include the schema name in sql queries

Created by Morten Christensen 04 Jun 2018, 11:22:39 Updated by Sebastiaan Janssen 27 Aug 2018, 06:10:39

The queries that are currently used in the SqlServerSyntaxProvider doesn't take the schema name into account, which means that it is not possible to have multiple Umbraco databases within the same "physical" database separated by schema. Imagine that you have one sql server database that you want to use or re-use for different umbraco databases - a scenario could be testing automated upgrades where you make a copy into a different schema, so you don't end up corrupting or losing the original one. Another scenario could be a branch (feature branch) of an umbraco site where you keep using the same database, so you avoid having to create a new database and change connection strings in the site to get it working. Simply having the schema name as part of all sql queries would enable this and that is what the PR https://github.com/umbraco/Umbraco-CMS/pull/2322 implements for SQL Server.

I'm actually not sure if SQL CE has the same concept of schemas as SQL Server, but for now the SQL Server approach is what is interesting - especially from an Umbraco Cloud perspective.

Comments

Priority: Normal

Type: Feature (request)

State: Fixed

Assignee:

Difficulty:

Category:

Backwards Compatible: True

Fix Submitted:

Affected versions:

Due in version: 7.13.0

Sprint:

Story Points:

Cycle: