2011

Table Of Contents
Automatically Linking Database Records to Objects . . . . . . . 530
Converting Object Data to Database Links . . . . . . . . . . . . 533
Editing Database Links . . . . . . . . . . . . . . . . . . . . . . . 536
Editing a Link Template . . . . . . . . . . . . . . . . . . . . . . 538
Using Open Source FDO Providers . . . . . . . . . . . . . . . . . . . 540
Bringing In AutoCAD Civil 3D Data . . . . . . . . . . . . . . . . . . . 543
Chapter 4
Managing Data . . . . . . . . . . . . . . . . . . . . . . . . . 547
Overview of Managing Data . . . . . . . . . . . . . . . . . . . . . . . 547
About Geospatial Feature Classes, Data Stores, and Schemas . . . . . . 551
Overview of Geospatial Data . . . . . . . . . . . . . . . . . . . 551
Working with FDO Schemas . . . . . . . . . . . . . . . . . . . . 553
Working with Oracle Data . . . . . . . . . . . . . . . . . . . . . 554
Working with SQL Server Data . . . . . . . . . . . . . . . . . . 559
Working with SQL Server Spatial Data . . . . . . . . . . . . . . 561
Working with SQLite Data . . . . . . . . . . . . . . . . . . . . . 565
Working with MySQL Data . . . . . . . . . . . . . . . . . . . . 567
Working with SDF Data . . . . . . . . . . . . . . . . . . . . . . 569
Working with SHP Data . . . . . . . . . . . . . . . . . . . . . . 572
Working with PostgreSQL/PostGIS Data . . . . . . . . . . . . . . 574
Working with ODBC Data . . . . . . . . . . . . . . . . . . . . . 576
Working with ESRI ArcSDE Data . . . . . . . . . . . . . . . . . . 579
Working with WFS Data . . . . . . . . . . . . . . . . . . . . . . 581
Working with Feature Sources . . . . . . . . . . . . . . . . . . . . . . 582
Overview of Working with Feature Sources . . . . . . . . . . . . 582
Setting Up Database Users . . . . . . . . . . . . . . . . . . . . . 584
Creating a Data Store . . . . . . . . . . . . . . . . . . . . . . . 586
Creating FDO-Enabled SQL Server Spatial Data Stores . . . . . . 590
Deleting a Feature Source . . . . . . . . . . . . . . . . . . . . . 593
Working with Schemas . . . . . . . . . . . . . . . . . . . . . . . . . . 593
Overview of Working with Schemas . . . . . . . . . . . . . . . . 594
Creating a Schema . . . . . . . . . . . . . . . . . . . . . . . . . 596
Setting Up Constraints in the Schema Editor . . . . . . . . . . . 599
Exposing a Native Database View in a Schema . . . . . . . . . . 603
Importing and Exporting a Schema . . . . . . . . . . . . . . . . 606
Viewing a Schema . . . . . . . . . . . . . . . . . . . . . . . . . 608
Editing a Schema . . . . . . . . . . . . . . . . . . . . . . . . . . 610
Deleting Schemas . . . . . . . . . . . . . . . . . . . . . . . . . 613
Undoing Schema Changes . . . . . . . . . . . . . . . . . . . . . 614
Migrating Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 615
Overview of Migrating Data . . . . . . . . . . . . . . . . . . . . 616
Migrating GIS Data (Bulk Copy) . . . . . . . . . . . . . . . . . . 617
Understanding How Bulk Copy Converts Data Types . . . . . . 623
Fixing Geometry Issues After a Bulk Copy . . . . . . . . . . . . 625
Reviewing the Bulk Copy Log Information . . . . . . . . . . . . 626
Migrating DWG Data to GIS . . . . . . . . . . . . . . . . . . . . 628
Contents | vii