Hi Experts
We are wanting to set up a new cloud Dynamics environment and import data from an on premise environment that contains multiple divisions data (including ours), that includes a few custom tables but with many fields that we don't need.
We are going to rebuild the environment in a new cloud version with the same custom tables but not all fields.
We will just be extracting our division specific data from the current on premise environment which will stay operating.
We are not a big organisation with complex needs but just want the current data to keep the created date and created by and maybe the modified on and by.
We also have contacts that have associated SharePoint documents.
What is the best way to do this?
Create the environment as we want it and use the import tool for each table?
OR is there an easy migration tool we can use to do this?