I have downloaded the AdventureWorks Azure database to test the DAC Export/Import with it.
The followings are NOT Azure compliant and fail on export or import:
- The table DatabaseLog does not have a clustered primary key. I had to add one for export to work.
- The stored procedure uspSearchCandidateResumes uses the functions FREETEXTTABLE AND CONTAINSTABLE, which are not supported on SQL Azure. I had to remove this procedure to make import work.