Map Question

Question

We have a map feature with the attributes stored in an msascess table linked by entity/mslink. 
 Additional attributes are required by this feature so the existing records will have to be migrated to a new table and the new fields added. 
 Any suggestions how this can be done in Map?

Jerry Walter - Bentley · Answer

What you are doing is creating ‘n’ new features, as far as the database is concerned. You could approach this through the GSA or manually edit the xml file and refresh in the GSA. 
 
All GSA 
1.	Create the tables in the database. 
2.	Remove the properties of the existing feature that are now represented by the new tables. 
3.	Refresh the database connection, getting the new tables. 
4.	Add the properties from the new table to the existing feature(s). 
5.	Update the SQL statements. 
6.	Update the placement metadata. 
7.	Export the workspace(s). 
 
Edit the XML file directly. ( I am assuming the existing column names will not change when going to the new table) 
 
1.	Create the tables in the database. 
2.	Change the name of the table in the XML file for the feature. 
3.	Open the GSA. 
4.	Refresh the database connection. 
5.	Add the new properties from the new table to the existing feature(s). 
6.	Update the SQL statements. 
7.	Update the placement metadata. 
8.	Export the workspace(s). 
 
The second method may seem like more steps, but step 2 allows you to just change the table name and not have to remove and reinsert the properties for the features, which can be tedious. 
 
Either method, please make a backup copy of the XML file before editing.