Hey Johanna
Some things to check
1. Your records have a srid recorded that aligns with the srid recorded for
the dataset. You can check this by querying in SQL Server with query
"select .STSrid from ". Compare this with what you have
recorded in the geometry_columns table for the table. They
Thanks Bo Victor for that suggestion, but that is not the problem.
I should have mentioned that I had already tried changing the symbology.
Johanna Botman
Assets / GIS Officer - Melton City Council
Hi Johanna -
I suspect, you have some symbology issues with the layer/table from DB1
Try to
Hi Johanna -
I suspect, you have some symbology issues with the layer/table from DB1
Try to change the symbology from "whatever it is now" to a "Single
symbol" for the DB1 layer and check if your missing objects appear
Med venlig hilsen / Kind regards
Bo Victor Thomsen
Den 08-06-2021 kl.
Hi,
I have a situation where I have two SQL databases and I have to move data from
one to the other. Always the same direction from DB1 to DB2
My issue is that the items show in some tables in DB1 but do not display in
QGIS.
I can select from the table, but I can't select items on the QGIS