We are going to migrate our on-premise application to cloud (Azure).
Consultant asks us to backup the current database in BACPAC format instead of BAK.
May I ask
1) Is there any reason we use BACPAC instead of BAK ?
2) It appears that it will take longer to create BACPAC file than BAK though the size of BACPAC file is much smaller than BAK file. Is it correct ?
3) Do we need to resolve all errors when we export current on-premise database to BACPAC file ?