topic Re: Setting Env. in Python when you are working with 2 databases on separate servers in Python Questions https://community.esri.com/t5/python-questions/setting-env-in-python-when-you-are-working-with-2/m-p/553930#M43278 <HTML><HEAD></HEAD><BODY><P>Some discussion on creating paths...</P><P><A href="https://community.esri.com/blogs/dan_patterson/2016/08/14/filenames-and-file-paths-in-python">/blogs/dan_patterson/2016/08/14/filenames-and-file-paths-in-python</A>&nbsp;</P></BODY></HTML> Tue, 27 Dec 2016 19:15:23 GMT BlakeTerhune 2016-12-27T19:15:23Z Setting Env. in Python when you are working with 2 databases on separate servers https://community.esri.com/t5/python-questions/setting-env-in-python-when-you-are-working-with-2/m-p/553926#M43274 <HTML><HEAD></HEAD><BODY><P>I've attached the script I am working on. It is a basic script set-up to sync changes between two replicated sde geodatabases. They are replicated fine, and manual sync works fine but I've been wanting to automate it. The thing I'm unsure of, is... what do I set the environment to if both of these databases exists on different SQL Servers?</P><P></P><P>The only python scripts I have created have to do with reconciling version or compressing an sde, but for all of that, the environment is just a single SDE database.&nbsp;</P><P></P><P>What do I do if the script needs to interact with two databases not in the same location?</P></BODY></HTML> Thu, 22 Dec 2016 16:40:22 GMT https://community.esri.com/t5/python-questions/setting-env-in-python-when-you-are-working-with-2/m-p/553926#M43274 deleted-user-t3dSviijg-m9 2016-12-22T16:40:22Z Re: Setting Env. in Python when you are working with 2 databases on separate servers https://community.esri.com/t5/python-questions/setting-env-in-python-when-you-are-working-with-2/m-p/553927#M43275 <HTML><HEAD></HEAD><BODY><P>Looking at the attached script, the basic question boils down to calling <SPAN style="font-family: courier new,courier,monospace;">arcpy.SynchronizeChanges_management</SPAN>.&nbsp; Instead of setting a workspace (<SPAN style="font-family: courier new,courier,monospace;">arcpy.env.workspace</SPAN>) and passing only the SDE connection file name, pass the full path to the SDE connection files.&nbsp; I don't know if it is a best practice or not, but I always pass full paths to geodatabases&nbsp;and SDE connection files&nbsp;because then I am not dependent on what the workspace is set to.</P></BODY></HTML> Thu, 22 Dec 2016 18:13:09 GMT https://community.esri.com/t5/python-questions/setting-env-in-python-when-you-are-working-with-2/m-p/553927#M43275 JoshuaBixby 2016-12-22T18:13:09Z Re: Setting Env. in Python when you are working with 2 databases on separate servers https://community.esri.com/t5/python-questions/setting-env-in-python-when-you-are-working-with-2/m-p/553928#M43276 <HTML><HEAD></HEAD><BODY><P>This makes sense. It didn't dawn on me but, I keep all my SDE connection files in the same folder. I could essentially set the full file path to that folder as the workspace right? Alternatively, in this case... I'm not sure if I need to set a workspace. If I specify each gdb in the parameters of arcpy.SynchronizeChanges_management, I don't think a workspace is necessary since the gdb's are "hardcoded" into the script essentially. I think so?</P></BODY></HTML> Thu, 22 Dec 2016 18:33:06 GMT https://community.esri.com/t5/python-questions/setting-env-in-python-when-you-are-working-with-2/m-p/553928#M43276 deleted-user-t3dSviijg-m9 2016-12-22T18:33:06Z Re: Setting Env. in Python when you are working with 2 databases on separate servers https://community.esri.com/t5/python-questions/setting-env-in-python-when-you-are-working-with-2/m-p/553929#M43277 <HTML><HEAD></HEAD><BODY><P>My suggestion, don't bother setting the workspace unless the tool absolutely requires it.&nbsp; Use full paths to workspaces, geodatabases, etc...</P></BODY></HTML> Thu, 22 Dec 2016 20:04:33 GMT https://community.esri.com/t5/python-questions/setting-env-in-python-when-you-are-working-with-2/m-p/553929#M43277 JoshuaBixby 2016-12-22T20:04:33Z Re: Setting Env. in Python when you are working with 2 databases on separate servers https://community.esri.com/t5/python-questions/setting-env-in-python-when-you-are-working-with-2/m-p/553930#M43278 <HTML><HEAD></HEAD><BODY><P>Some discussion on creating paths...</P><P><A href="https://community.esri.com/blogs/dan_patterson/2016/08/14/filenames-and-file-paths-in-python">/blogs/dan_patterson/2016/08/14/filenames-and-file-paths-in-python</A>&nbsp;</P></BODY></HTML> Tue, 27 Dec 2016 19:15:23 GMT https://community.esri.com/t5/python-questions/setting-env-in-python-when-you-are-working-with-2/m-p/553930#M43278 BlakeTerhune 2016-12-27T19:15:23Z