Description of problem: RTGov and DTGov generate their database tables with SQL Server 2008 dialect using untyped access: unitId varchar(255) not null As this data is actually in UUID format, it should be stored as: unitId uniqueidentifier not null The advantages is that this column uses only 16 bytes of data (instead of 36 bytes which is the minimum when stored as varchar). Version-Release number of selected component (if applicable): FSW6.0.0beta How reproducible: Steps to Reproduce: 1. 2. 3. Actual results: Expected results: Additional info:
Assigning to Steve. SQLServer is not a supported DB for the beta release but this will be addressed by Final.
We do not see this as a blocker for the release as there is no functional impact to this issue other than saving space.