<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@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;}
/* Style Definitions */
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;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
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]-->
</head>
<body lang="EN-AU" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<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>
</body>
</html>