Export backpac file from on prem

Following are steps to export the backpac file from the SQL on premises databases:

Goto Local Database Properties >Select Task > Select Export Data-tier Application

Next >
Browse > Select local disk location to save backpack export file. 
Advanced > Select Tables as per requirement 
Check Summary
Faced multiple Error of elements which are not supported in Azure  
Kept only those table are supported
Export completed successfully.

Post a Comment