ArcGIS Desktop

  • ArcGIS Pro
  • ArcMap

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

ArcMap

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • Extensions

Multiple geodatabases in SQL Server

If you want to create more than one geodatabase in the same SQL Server instance, you create multiple SQL Server databases, create a geodatabase in each one, and authorize each geodatabase.

The following graphic illustrates that there are two separate databases on one SQL Server instance, and each database contains a complete geodatabase comprised of geodatabase system objects and user data:

Two geodatabases in one SQL Server instance

The databases can have any unique name that follows SQL Server rules for identifiers and does not start with a number.

You can use the Create Enterprise Geodatabase tool to create additional databases and geodatabases in a SQL Server instance. Since you already designated the geodatabase administrator user when you created the first geodatabase, be sure to use the same password for the geodatabase administrator when you run the tool a second time.

Client connections can be made to one geodatabase at a time. When connected to a geodatabase on a SQL Server instance, you cannot query information from another geodatabase on the SQL Server instance through that same connection.

For instance, you could connect to database1 in ArcGIS Desktop. When you add data to ArcMap through that connection, you cannot view the data in database2. To access the data in database2, you would set up a second database connection from ArcMap to database2.

Legacy:

In ArcSDE 9 to 10, two different data storage models were supported for SQL Server: multiple and single spatial database models. The multiple spatial database model is no longer supported. You cannot create new geodatabases in the multiple spatial database model and you cannot add users to or upgrade existing ones. See Migrate from a multiple-database to a single-database geodatabase in SQL Server for tips on moving from the multiple spatial database model to the single database model.

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS
  • ArcGIS Developer
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2021 Esri. | Privacy | Legal