How can I export external content type as a BDCM file with powershell?

Question

I can export external content type from SharePoint Designer or Central Administration. However, I want to export ect as bdcm file with powershell in order to export ect automatically.

There is an exapmle in techNet Export-SPBusinessDataCatalogModel;

  $Model = Get-SPBusinessDataCatalogMetadataObject -BdcObjectType "Model" - Name "ContosoModel"  -ServiceContext http://contoso  
  Export-SPBusinessDataCatalogModel -Identity $Model -Path "C:\folder\model.bdcm"  

File was created with this command but the file content is not similar with SP Designer export file.

How can I do that.

Answer 1

Try change -BdcObjectType Model to LobSystem

Answer 2

I've used this in the past with success for a full catalog

$mybcsMeta = Get-SPBusinessDataCatalogMetadataObject –ServiceContext http://sp.local –BDCObjectType Catalog –Name MyModel
Export-SPBusinessDataCatalogModel –Identity $mybcsMeta –Path C:\BCS_Model.bdcm

The differences could come from the use of the parameters which have different defaults via UI(SPD or SPCA vs Powershell).

• ModelsIncluded —Models are included in the exported XML file
• PermissionsIncluded —The permissions to the model are included in
  the export
• PropertiesIncluded —Specifies that BCS properties are included in the export