topic Re: Database connections vs Database servers in Data Management Questions

Database connections vs Database servers

faisalmoeen — Tue, 11 Oct 2011 10:11:33 GMT

Hello,
There are two options to connect to database servers through arccatalog, Add Database Connections and Add Database Server. Whats the difference?
I have an Oracle DB configured with ArcSDE as geodatabase. I am able to connect through "Database Connections" in Arccatalog. Can I use Add Database Server?

regards

Re: Database connections vs Database servers

JakeSkinner — Tue, 11 Oct 2011 10:40:47 GMT

The option 'Add Database Server' is only for ArcSDE Workgroup and ArcSDE Personal editions. Both of these versions are only available for SQL Server Express. ArcSDE Workgroup and Personal are pretty much scaled down versions of ArcSDE. You are limited to storage, number of editors, and number of connections. Since you are using Oracle, you are using ArcSDE Standard or Advanced edition.

Re: Database connections vs Database servers

VinceAngelo — Tue, 11 Oct 2011 10:45:38 GMT

"Database Connections" are to Enterprise ArcSDE servers. "Database Servers" are Personal and
Workgroup ArcSDE (MS SQL-Server Express) instances. The documentation has the details.

- V

Re: Database connections vs Database servers

faisalmoeen — Tue, 11 Oct 2011 19:46:29 GMT

Got it....thanks

Re: Database connections vs Database servers

RichardLittlefield — Thu, 10 May 2012 16:44:33 GMT

Hello,
There are two options to connect to database servers through arccatalog, Add Database Connections and Add Database Server. Whats the difference?
I have an Oracle DB configured with ArcSDE as geodatabase. I am able to connect through "Database Connections" in Arccatalog. Can I use Add Database Server?

regards

We have ArcGIS for Server - Standard and Wrokgroup. In ArcCatalog we can see geodatabases under both areas, the Database Server and the Database Connections. What is the difference between the two? Where should we be storing our data? Which one is better?

Re: Database connections vs Database servers

JakeSkinner — Fri, 11 May 2012 11:31:08 GMT

Hi Richard,

Database Servers is used only for a SQL Server Express instance. You can create a connection here to your SQL Server Express databases and perform administrative tasks such as creating users, administer database privileges, and creating databases.

You can also create a connection to your SQL Server Express databases under 'Database Connections', however you cannot perform any administrative tasks. This is typically used for other Enterprise Databases such as Oracle, SQL Server (Standard or Enterprise), PostgreSQL, DB2, or Informix.

If you have a connection to your SQL Server Express instance under both Database Servers and Database Connections, data loading will be the same. You are presented with the same loading options and performance. You will want to create a connection to your SQL Server Express instance under Database Connections if you plan to publish data from SDE to ArcGIS Server. A connection here creates an SDE connection file (.sde) that the 'ArcGISSOC' user will need Read privileges to.