topic Changing SDE data source using Python: query layers vs feature layers in Python Questions https://community.esri.com/t5/python-questions/changing-sde-data-source-using-python-query-layers/m-p/34227#M2665 <HTML><HEAD></HEAD><BODY><P>I have a bunch of MXD and I need to change the SDE connection in them using Python. These MXD include sde feature layers, sde tables and query layers.</P><P>For sde feature layers and tables replaceWorkspaces work as expected but it does not for query layers.</P><P>I tried with findAndReplaceWorkspacePaths and it works for query layers but NOT for sde feature layers.</P><P>So I guess I should combine both methods to get all the layers' connections changed, but this means changing the data source twice for every MXD. Isn't there a single method to do this all at once? I need all the process to be as fast as possible.</P></BODY></HTML> Thu, 28 Jul 2016 09:29:43 GMT AleydisG__Pere 2016-07-28T09:29:43Z Changing SDE data source using Python: query layers vs feature layers https://community.esri.com/t5/python-questions/changing-sde-data-source-using-python-query-layers/m-p/34227#M2665 <HTML><HEAD></HEAD><BODY><P>I have a bunch of MXD and I need to change the SDE connection in them using Python. These MXD include sde feature layers, sde tables and query layers.</P><P>For sde feature layers and tables replaceWorkspaces work as expected but it does not for query layers.</P><P>I tried with findAndReplaceWorkspacePaths and it works for query layers but NOT for sde feature layers.</P><P>So I guess I should combine both methods to get all the layers' connections changed, but this means changing the data source twice for every MXD. Isn't there a single method to do this all at once? I need all the process to be as fast as possible.</P></BODY></HTML> Thu, 28 Jul 2016 09:29:43 GMT https://community.esri.com/t5/python-questions/changing-sde-data-source-using-python-query-layers/m-p/34227#M2665 AleydisG__Pere 2016-07-28T09:29:43Z Re: Changing SDE data source using Python: query layers vs feature layers https://community.esri.com/t5/python-questions/changing-sde-data-source-using-python-query-layers/m-p/34228#M2666 <HTML><HEAD></HEAD><BODY><P>What if you detect the type of data source and apply the suitable method per layer type?</P></BODY></HTML> Thu, 28 Jul 2016 11:21:16 GMT https://community.esri.com/t5/python-questions/changing-sde-data-source-using-python-query-layers/m-p/34228#M2666 XanderBakker 2016-07-28T11:21:16Z Re: Changing SDE data source using Python: query layers vs feature layers https://community.esri.com/t5/python-questions/changing-sde-data-source-using-python-query-layers/m-p/34229#M2667 <HTML><HEAD></HEAD><BODY><P>I may be wrong but my guess is that changing the data source for each layer separately will be slower.</P><P>Also, the only way to detect if a layer is a query layer is to look for the string '%' in its datasetName as mentioned <A _jive_internal="true" href="https://community.esri.com/message/613281#comment-613281">here</A>. I haven't tested it though.</P></BODY></HTML> Thu, 28 Jul 2016 12:34:09 GMT https://community.esri.com/t5/python-questions/changing-sde-data-source-using-python-query-layers/m-p/34229#M2667 AleydisG__Pere 2016-07-28T12:34:09Z