When a new field gets added to SQL server table how to update its sharepoint BDC external list

When a new field gets added to SQL server table how to update its BDC external list:

  1. Navigate to the SharePoint site and delete the existing BDC external list.
  2. Now open SharePoint Designer and copy (take screen shot) of the existing permissions.
  3. Now from LHS navigation menu of External Content Types, select the one which needs updated, and do right click and do delete.
  4. Now following the previous posting for creating the new one.
  5. While selecting the table, if the newly added field doesn’t appear then delete and re-add and refresh the table and make sure the newly added column appears.
  6. By logging onto Central Admin adjust the permissions.
  7. Go tot SharePoint site and create the external BDC list.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s