Handle schema differences

If there are schema differences between your on-premises tables and the cloud tables, a general approach to work around this is:

1. Use the Bulk Copy Program (BCP) to import the data into temporary tables with the same schema as your existing database.

2. Move the data into the new tables created from the BACPAC file, accounting for the differences in schemas. Some examples of differences are:

   1. Changing a Name to an ID.

   2. Filling in non-nullable columns.

3. Migrate the data from the tables in the database based on the BACPAC file to the cloud production database using the measDataLoader utility.