2011

4 After you are connected, follow the instructions on the screen.
If you are adding a user, enter the user name and password.
New users you create with this utility automatically have the roles and
privileges required by the AutoCAD Map 3D FDO functionality. However,
FDO User Manager allows you to grant some additional privileges. Use
commas to separate the role names, with no spaces. You can enter ? to
see a list of roles. To verify the roles after you add them, select List All
Roles And Privileges Of A User.
5 When you finish, enter 0 (a zero) to exit FDO User Manager.
Creating a Data Store
Features are stored in a
data store (page 2059), which is a collection of feature
classes in a single data storage location. To add a feature to your map, you
connect to its data store and select each feature class (page 2063) to include.
The main reason to create a new data store is to
migrate existing data (page
615) to the new
FDO provider (page 2063), or to create new data in that provider
format.
NOTE This functionality affects geospatial feature data only. For information about
linking records in an external database to objects in a drawing, see
Overview of
Linking Database Records to Objects
(page 522). For information about moving
data between DWG and geospatial formats, see
Migrating DWG Data to GIS (page
628).
You can create new data stores for database FDO Providers (Microsoft SQL
Server, SQL Server Spatial, MySQL, PostgreSQL/PostGIS, or Oracle) and
file-based FDO Providers (SDF, SHP, or SQLite) from within AutoCAD Map 3D
if you have the necessary privileges for the target database or directory. After
you create a data store, you can define or import a schema for it, which
specifies the feature classes available in that data store and their properties.
Before creating a database data store, make sure you have
created a user for
the data store with the proper privileges
(page 584).
To overwrite an existing data store, you must first delete the old one. For data
stores from database FDO Providers, use DBMS-specific tools to drop existing
tables.
After you create a data store and
define a schema (page 596) for it, AutoCAD
Map 3D users can create, store, and
access (page 303) geospatial data in that
data store.
586 | Chapter 4 Managing Data