1
Vote

Incompatibilites with SQL Azure on Export/Import

description

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.

comments