how to create a duplicate data extension from a synchronized DE without manually typing all fields for the new DE

Question

I'm trying to create a new DE from an existing synchronized DE with all the fields prepopulated. When I create the DE I want it to copy all the fields and field types for the synchronized DE to the new DE without me having to either manually typing them or using the SOAP API. I tried creating a filter from the synchronized DE but that will not solve my issue. I need it to be specifically a "standard" DE rather than a filter. Is this by any chance possible at this moment?

Answer 1

If you are not willing to type it manually or use SOAP API, there is another way to go: using Deployment Manager.

Use Deployment Manager to copy the design of a journey or data extension and deploy it to other Marketing Cloud business units or enterprises. You can then configure the new draft journey or data extension design in the target account. Deployment Manager doesn’t store or migrate any customer or campaign data.

Steps to follow:

1- Install the Deployment Manager on your BU --> Help

2- Create a Snapshot of your DE and download it --> Help

3- Deploy the Snapshot on the same BU --> Help

I've tested creating a Filtred DE, create a Snapshot and deploy it. It actually deploys a Standard DE instead of filtered DE which responds to your use case.

Hope this helps