SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have used Sharepoint designer 2010 to make SQL server tables available as external content types (and lists) for a site collection but what about across multiple site collections--can this be done?

share|improve this question

External content types are available at farm level so you should have no problems accessing them across site collections. Just make sure you have the permissions set correctly.

share|improve this answer

My understanding is that the Managed Metadata functionality will allow you to publish your content types across site collections. However, it doesn't appear that the Managed Metadata supports external content types just yet. Seems that the only option at this point would be a script to replicate the external list across your site collections.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.