KFS Fixpack 8 cannot be installed, because DB schema is not dbo
Article # 3032462 - Page views: 79
Issue
Latest KFS FP cannot be installed due to DB Schema is unequal to "dbo".
How can I change DB schema for KFS database?
Solution
1.) ALTER SCHEMA NewSchemaName TRANSFER OldSchemaName.ObjectName -> (please notice that ALTER SCHEMA must be done per DB object (Table, SP orView))
2.) User must have appropriate permission to DB
3.) run the KFS SP or FP update
4.) keep dbo schema or change back to old schema, steps are the same as in 1.)
How to change schema of all tables, views and stored procedures in MSSQL:
Level of Complexity
Moderate
Applies to
Product | Version | Build | Environment | Hardware |
---|---|---|---|---|
KFS | 4.3 |
References
Add any references to other internal or external articles
Article # 3032462