<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
</head>
<body>
<p>Hi Johanna - <br>
</p>
<p>I suspect, you have some symbology issues with the layer/table
from DB1</p>
<p>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<br>
</p>
<pre class="moz-signature" cols="72">Med venlig hilsen / Kind regards
Bo Victor Thomsen</pre>
<div class="moz-cite-prefix">Den 08-06-2021 kl. 08:39 skrev Johanna
Botman:<br>
</div>
<blockquote type="cite"
cite="mid:MEYP282MB2120E642946423982AEFB5C9DC379@MEYP282MB2120.AUSP282.PROD.OUTLOOK.COM">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style>@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}div.WordSection1
{page:WordSection1;}</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">Hi,<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">My issue is that the items show in some
tables in DB1 but do not display in QGIS.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I can select from the table, but I can’t
select items on the QGIS canvas<o:p></o:p></p>
<p class="MsoNormal">I can cut and paste from DB1 to DB2 and the
items display in DB2.
<o:p></o:p></p>
<p class="MsoNormal">I can manually create an item in an
affected table in DB1 and it will display.
<o:p></o:p></p>
<p class="MsoNormal">When I hover with my Add
[polygon/line/point] tool, the square to show where the
vertices (for snapping) are displayed as I move my cursor over
them.<o:p></o:p></p>
<p class="MsoNormal">When I run the Validate Geometry tool, the
results are that I have valid geometry and those layers are
displayed.<o:p></o:p></p>
<p class="MsoNormal">In SQL server manager I can see the spatial
results for those tables in DB1.<o:p></o:p></p>
<p class="MsoNormal">Projections are the same for each DB<o:p></o:p></p>
<p class="MsoNormal">There are no Layer Scale Visibility
settings in play for either DB<o:p></o:p></p>
<p class="MsoNormal">It does not affect all tables in DB1.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Can anyone suggest some further
troubleshooting strategies?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b><span
style="font-size:12.0pt;mso-fareast-language:EN-AU"><o:p> </o:p></span></b></p>
<p class="MsoNormal"><b><span
style="font-size:12.0pt;mso-fareast-language:EN-AU"><o:p> </o:p></span></b></p>
<p class="MsoNormal"><b><span
style="font-size:12.0pt;mso-fareast-language:EN-AU">Johanna
Botman<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-AU">Assets
/ GIS Officer – Melton City Council<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial",sans-serif;mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial",sans-serif;color:#1F497D;mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p><br>
***********************************************************************************<br>
The information in this message is privileged and confidential,
intended only for the use of the individual or entity named
above. If you are not the intended recipient you are hereby
notified to delete the message and that any dissemination,
copying or use of its content is strictly prohibited. If you
have received this message in error please notify the Melton
City Council.<br>
***********************************************************************************</p>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
</pre>
</blockquote>
</body>
</html>