Latest Contributions by Asrujit_SenGupta

Read versioned data in SQL Server using versioned views—Help | ArcGIS Desktop  Read a specific version state If you want to query a specific state of the Default version and don't want the state to change while you are querying, execute the set_current_version stored procedure. This procedure validates the supplied version name and sets the corresponding database state internally. If you execute set_current_version for the Default version, queries you make against Default will always point to the state Default referenced when you executed the set_current_version stored procedure. Set_current_version can be executed directly from an SQL client. The syntax is as follows for an sde-schema geodatabase: EXEC sde.set_current_version '<version_name>' For dbo-schema geodatabases, the stored procedure is owned by dbo, so the syntax is as follows: EXEC dbo.set_current_version '<version_name>' ... View more

Honestly, these kind off questions (about upcoming releases or support for new versions) will be best answered by contacting Esri Tech Support. ... View more

Is this what you are looking for: https://community.esri.com/ideas/12671 ? ... View more

https://community.esri.com/thread/3884  Check this as well... ... View more

No, that is needed to create an Enterprise geodatabase. Check this link on how to create a Desktop geodatabase: Set up a database server—Help | ArcGIS Desktop  ... View more

The File gdb cannot be a Parent replica gdb, but the Desktop gdb can be. The parent always has to be an SDE gdb ( Desktop gdb, Workgroup gdb or Enterprise Gdb). The child gdb can be a File gdb in some cases, depending upon the type of replica you choose to use. ... View more

Choosing among these will depend upon what your organisation needs are. Performance is something, which you will probably have to test for yourself. It will depend upon the type of data, amount of data and a lot many other factors. Generally speaking, if you won't be using too much data, you will probably observe File gdbs performing better than any SDE gdb. Some of the other things to consider: 1. How much data will be loaded in the geodatabase (The Desktop gdb has a size limitation of 10GB per database, because the underlying Database is SQL Server Express) 2. How many editors will be editing simultaneously. (Only one user can edit at one given time in a Desktop gdb) 3. Are you planning to implement any functionality like Replication, Archiving, etc I am branching this out as a separate question, as this a different question and so that others can also contribute with their opinions Some previous discussions that you can check: SDE or File Geodatabase  Performance Metrics ArcSDE vs File Geodatabase  https://community.esri.com/thread/45017  ... View more

Christopher McClain wrote: It is not necessary to unversion a GDB before making the changes you indicated.  However, make sure you are making the changes as the database owner. Only one thing to change in the answer above....it should be data owner and not database owner.. ... View more

Starting from 10.3, the SDE Command line tools were deprecated. Esri introduced the capability to Register Views with Geodatabase using GP Tools at 10.5. Take a look at the below links: https://community.esri.com/groups/geodatabase/blog/2016/12/14/new-at-105-registering-a-database-view-with-the-geodatabase  Register a table or view with the geodatabase—ArcGIS Help | ArcGIS Desktop  ... View more

You cannot grant additional Privileges to any login to make it Data Owner or make those options under Manage to be available. Let's say, that you used a login named 'GIS_owner' to connect and create a feature class. The data shows up as "Db_name.GIS_owner.FC_name". In this case, only when you connect as 'GIS_owner', you get those options under Manage. This is simply because, only the data owner (the person who created the data), has the right to grant Privileges to other logins to View\edit that data and so on. Even if you connect as an Admin (login with 'sysadmin' permission, which is the highest possible in SQL Server), you will not get those options under Manage. So this is not about what roles\permissions you have. Can you provide us an example of how your Data looks? A screenshot (with the db_name and Data_name grayed out if needed) or simply type in, and we can suggest better. ... View more

How To: Recover connections, styles, and templates from an archived application data folder  arcgis desktop - Recover Folder Connections - Geographic Information Systems Stack Exchange  The old "ArcCatalog.gx file" should do the trick, if you have a copy of that. ... View more

There are some tasks, which only the Data Creator can perform. No other user, even sysadmin, can do these. Those options under 'Manage', will only be available when you connect as the same user which was used to create the Data. If the data is owned by DBO, then any login with 'sysadmin' server role granted to it, can perform those tasks. ... View more

No, you cannot edit a *.sde connection file. Your users use Windows Authentication or SQL Server Authentication? If it is Windows Authentication, you can simply create a Windows Authenticated connection file and provide that to the users... ... View more

Taking Python out of the equation....did you try simply executing the GP Tool in ArcGIS Desktop? ... View more