I'm in the early stages of developing a SQL Server data warehouse that will maintain geographic/spatial data. I'm new to anchor modeling and wondering if the online tools support the SQL Server geographic data type. Any experience or ideas?
It does support the geography type, but you will need to check the "Checkum" box in attributes or knots using the type. This is because of the fact that equality (and other comparison operators) cannot be used directly with the type.