database-servers-tutorial.pdf
(
943 KB
)
Pobierz
727207388 UNPDF
Database Servers Tutorial
Copyright © 1995-2010 Esri All rights reserved.
Database Servers Tutorial
Table of Contents
A quick tour of the database servers tutorial . . . . . . . . . . . . . . . . . . . . . . . . 3
Exercise 1: Add a database server to the Catalog tree and create a geodatabase . . . . . . . . . 5
Exercise 2: Load data into a geodatabase and update statistics . . . . . . . . . . . . . . . . 7
Exercise 3: Attach, create a backup of, and upgrade a geodatabase . . . . . . . . . . . . . . 10
Exercise 4: Add users and administer their permissions . . . . . . . . . . . . . . . . . . . 13
Exercise 5: Make nonversioned edits as a read/write user . . . . . . . . . . . . . . . . . . 18
Exercise 6: Restore a geodatabase . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
Exercise 7: Connect as a geodatabase administrator, load data, register it as versioned, and create a
version . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
Exercise 8: Making versioned edits as a read/write user . . . . . . . . . . . . . . . . . . . 28
Exercise 9: Compress the Osokopf geodatabase, rebuild indexes, and shrink the geodatabase while
logged in as a geodatabase administrator . . . . . . . . . . . . . . . . . . . . . . . . . 39
Exercise 10: Detach the buildings geodatabase from the database server . . . . . . . . . . . . 42
Copyright © 1995-2010 Esri. All rights reserved.
2
Database Servers Tutorial
A quick tour of the database servers tutorial
Within ArcGIS software, the term database servers refers to instances of Microsoft SQL Server Express that
have been enabled to store geodatabases.
You create geodatabases and perform other administrative tasks for database servers through the Database
Servers node in the Catalog window or ArcCatalog. Performing the administration of the database server and
its geodatabases through ArcGIS Desktop means there is no extra software or database administration
expertise required for you to create and use these types of ArcSDE geodatabases.
To get started using database servers, this tutorial will show you how to use ArcGIS Desktop to do the
following:
• Add a database server and create new geodatabases.
• Add users to the database server and grant permissions.
• Load data into the geodatabases.
• Make edits to data in a geodatabase on a database server.
• Perform administrative tasks, such as making a backup of and upgrading a geodatabase.
Getting started
To complete the tasks in this tutorial, you must install ArcGIS Desktop, Microsoft SQL Server Express, and
the tutorial data. You must also create additional logins on your computer to complete some of the tasks.
Software installation
For this tutorial, you must install ArcGIS Desktop (ArcEditor or ArcInfo license level), SQL Server Express,
and the ArcTutor data for this tutorial on your computer. Use the ArcSDE for SQL Server Express
Installation wizard provided on the ArcGIS Desktop installation media to install an instance of SQL Server
Express and enable it to create ArcSDE geodatabases. To complete the installation, follow the
instructions in the ArcSDE for SQL Server Express installation guide, which is also included with the
ArcGIS Desktop media.
You most likely already have ArcGIS Desktop installed, but if not, follow the instructions in the ArcGIS
Desktop installation guide to complete this. If the ArcTutor data has not been installed, you need to install
it using the ArcTutor executable provided on the ArcGIS Desktop media.
As with all software installations on Windows operating systems, you must be an administrator on the
computer to install SQL Server Express, ArcGIS Desktop, and the tutorial data. If you do not have
administrative rights to the computer you are going to use for this tutorial, have your systems
administrator install the software. Be sure the system administrator adds your login to the database server
as an ArcSDE database server administrator when he or she enables the SQL Server Express instance to
store geodatabases.
The ArcSDE database server administrator is responsible for maintaining the database server, creating
and maintaining geodatabases, and adding and administering their database server user accounts. This
tutorial shows you how to perform these tasks; therefore, without database server administrator
permissions, you could not complete this tutorial.
Copyright © 1995-2010 Esri. All rights reserved.
3
Database Servers Tutorial
Additional logins
Database servers exclusively use Windows-authenticated logins for authentication. This tutorial requires
three Windows logins: your login and two others.
If you are an administrator on your computer, you can create local Windows logins and use those. If you are
not an administrator, have your systems administrator either add two users to your computer or provide you
with two network logins to use.
You will use these logins to learn how to do the following:
• Add other users to your database server and grant them permission to the geodatabase and the
data it holds.
• Assess what the different levels of permission allow or prevent users from doing so you can decide
what sort of permissions you should grant to other users.
• Use the database server and its contents as a nonadministrative user. Therefore, if you connect to a
colleague’s database server on which you have restricted permission, you will know how to use it.
The creation of additional logins will be explained in
Exercise 4: Add users and administer their permissions
.
You will use the two additional logins in
Exercise 5 Make nonversioned edits as a ReadWrite user
,
Exercise
7: Connect as a geodatabase administrator
, and
Exercise 8: Make versioned edits as a ReadWrite user
.
Copyright © 1995-2010 Esri. All rights reserved.
4
Database Servers Tutorial
Exercise 1: Add a database server to the Catalog tree
and create a geodatabase
Once you have all of the software and tutorial data installed, connect to the
database server and create a geodatabase.
Complexity:
Beginner
Data Requirement:
ArcGIS Tutorial Data Setup
Goal:
Connect to a database server in ArcGIS
Desktop and create a geodatabase.
You connect to and administer database servers from the Catalog tree.
Therefore, open ArcMap and open a Catalog window.
Starting ArcMap and opening the Catalog window
Steps:
1. Start ArcMap by clicking
Start
>
All Programs
>
ArcGIS
>
ArcMap 10.
2. Click
Blank Map
under
New Maps
on the
ArcMap - Getting Started
dialog box and click
OK
.
3. Click the
Catalog Window
button on the Standard toolbar.
The
Catalog
window opens.
Adding a database server
One of the folders in the Catalog tree is called Database Servers. This is where you add a connection to the
database server.
Steps:
1. Expand the Database Servers node in the Catalog tree.
2. Double-click
Add Database Server
.
3. On the
Add Database Server
dialog box, provide the name of the ArcSDE database server.
This is in the form <server_name>\<instance_name>, where the server name is the name of
the server on which SQL Server Express is installed and the instance name is the name of the
SQL Server Express instance.
For example, if a database server is named SOPHIE\SQLEXPRESS, SOPHIE is the server
name and SQLEXPRESS is the instance name.
If you are unsure of the name to use, contact the administrator of the database server for this
information.
4. Click
OK
.
A new database server connection appears under the Database Servers node of the Catalog tree.
Creating a geodatabase
The database server administrator creates the geodatabases on the database server. Since you are the
database server administrator, you will create a geodatabase. Name the geodatabase Osokopf.
Steps:
Copyright © 1995-2010 Esri. All rights reserved.
5
Plik z chomika:
bambucza1989
Inne pliki z tego folderu:
maplex-tutorial.pdf
(2371 KB)
creating-geoprocessing-services-tutorial.pdf
(6679 KB)
data-interoperability-extension-tutorial.pdf
(2691 KB)
cartographic-representations-tutorial.pdf
(2492 KB)
netcdf-tutorial.pdf
(1402 KB)
Inne foldery tego chomika:
ArcGIS Podręcznik PL
ArcGIS TUTORIAL_POLSKIE
Dane do tutoriali ArcGIS
GeoMedia
IDRISI
Zgłoś jeśli
naruszono regulamin