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. I am waiting your help.. Thank you.

Answer 1

Hi,Please clarify what you mean by "the file content is not similar with SP Designer export file". What is the difference?

---

Dmitry

Lightning Tools Check out our SharePoint tools and web parts | Lightning Tools Blog

Answer 2

The difference is that bdcm file contents are not similar. SP Designer export file contains lobsystem information, finder and specific finder methods. However, when I get the bdcm file from powershell script, it contains just document header etc. I want to get bdcm file like SPDesigner exporting or Cent. Administration BCS exporting. I try to be clear, I hope so,  it is not still question marks in heads?

Thanks,

Answer 3

Hi,

If your BDC model was created in SPD I think you can't it export from Central Administration as you wish because it can be empty (the same result as using powershell). For example take a look at my example:

If I drill down into the model with name SharePointDesigner-Northwind-Administrator-2a90fa6d-f6f0-4f9c-96cb-17827630090d I see that this model is empty. So if I try to export this model from Central Administration it won't contain any entities.

---

Dmitry

Lightning Tools Check out our SharePoint tools and web parts | Lightning Tools Blog

Answer 4

Hi Dmitry,

Thank you for your answer, but I know that SPD and Central Administration are the appropriate way to export bdcm file, I have to write script to export bdcm file in .NET solution. I want to learn How can I export bdcm file with C# or powershell script.

Muhammed KACAR

Answer 5

Hi Muhammed,

Please take a look at this article Code Snippet: Export a BDC Model From the BDC Metadata Store

---

Dmitry

Lightning Tools Check out our SharePoint tools and web parts | Lightning Tools Blog