Control where to create the version in an MXD that has multiple database connections

06-27-2018 01:23 PM
Occasional Contributor III


I have an mxd file that I use as a template, this mxd references 2 databases (502 and 280 in the screenshot below). Now my question is when I try to create a version using create new version button in versioning tool bar then how to know which parent version is related to which database?? the drop down menu shows 2 parent versions with the same name dbo.default !!

I cannot till which till which is which, so If I am trying to create a new version to edit the schools I should do this in the 280 database but with the current window end up creating the version in the 502 database.

I am looking for method that doesn’t include trial and error.

Another method to do that is by using the version manager window then right click above the default version then create a new version. This window says the database that you’re in but it doesn’t have the capability to navigate between all databases in the mxd!!

I believe both of them depends on layer location in the TOC the above layer is the first one in the new version window and is the default in the version manager widow. 



0 Kudos
4 Replies
Occasional Contributor II

Hello Ahmad, 

 Although this doesn't really answer your question regarding the versioning toolbar or the GDB administration GUI- perhaps the Create Version GP tool (also scriptable) might provide what you are looking for since it is based on the input .sde connection file (to the respective database)- and therefore specific to the database you choose. Hope this helps!


Occasional Contributor III


You're right about the tool and I am aware of it, but I am trying to  limit the number of tools that the user runs, adding to that the time that take the  user to create the connection and drag drop it to the tool then run it.  In my case this is time  consuming. And I created a template to avoid all of these steps, the user should be  able to grab a copy of the template > change the version or create a new one> start editing.

Thank you though for you input.

0 Kudos
MVP Alum

Like the original poster, I am sort of curious about this too.  Typically, when I have an editing task to do in SDE I am pulling from both a default (non-editible production) SDE connection and an editable connection to the same data in SDE.  When I go to make a version, it always defaults to the non-editable connection, which is annoying.  The only way to create a version is to have only the editable SDE connection loaded into an mxd and then create the version, then pull that across to the mxd with the non-editable connection.  Not the end of the world, but annoying. 

So back to the original posters question, how does one specifically choose the correct database?  The selection window is a bit vague.  And in my case, how does on force it to be the connection I want?  Not to hijack this thread, but I am likewise curious.

Chris Donohue, GISP

Occasional Contributor III


As you said its not the end of the world, but its annoying that we cant control it. Thank you.