Converting Object Data to Database Links
Concept Procedure Quick Reference
 
 
 

If you plan to create a new table in an existing data source, make sure the appropriate data source is currently attached and connected.

Note During the conversion, field names in the object data table become field names in the database table. Make sure that the field names in your object data table are not SQL reserved words such as DATE, SELECT, or CURRENT. If necessary, rename the fields in your object data table before you convert it.

To convert object data to a linked database table

  1. At the Command prompt, enter mapod2ase.
  2. In the Convert Object Data to Database Links dialog box, under Source Object Data Table, select an object data table.
  3. Select Remove Data From Objects Processed to delete the object data after creating the link.
  4. Under Target Link Template, select Convert Object Data To Database.
  5. Click Define to specify the link template.
  6. In the Define Link Template dialog box, select an available data source. Click Connect.
  7. Enter a table name.
  8. Specify the fields to use as key fields (columns). To enter more than one field name, separate names with a comma.

    To select from a list of field names in the object data table, or to rename the fields, click Select to display the Select Link Template Key(s) dialog box.

    You can use an existing object data field as the key column or create a new field. If you select Generate Key Field, specify a name for the field in the Generate Key area. AutoCAD Map 3D sets the first record in the database table to 1, and increments each subsequent record by 1. Click OK to close the Select Link Template Key(s)

    dialog box
  9. In the Define Link Template dialog box, enter a name for the link template and click OK.

    The link template stores the address of the database table and the name of the key field. Accept the default or enter a new unique name.

  10. In the Convert Object Data To Database Links dialog box, specify how to select objects with attached object data.

    You can select objects automatically or manually, and you can use a filter to restrict selection to specified layers.

  11. Click Proceed.

AutoCAD Map 3D converts the object data into linked database tables.