SQLPackage Import BacPac Elastic Pool Limitation

[tomaustin700]

Hi,
Is there still a limitation of SQLPackage import into Elastic Pools like stated here: https://learn.microsoft.com/en-us/azure/azure-sql/database/database-import?tabs=azure-powershell&view=azuresql#limitations

We have successfully imported into an Elastic Pool previously however recently the process has been hanging at the start of the import (about 50% of the time), after investigating this issue I have found the stated limitation.

This is more just a question and not a bug so apologies for the incorrect label.

Thanks

[ErikEJ]

@tomaustin700 Sqlpackage based import does not have this limitation, only the Import Service as I read it..

[tomaustin700]

Thanks @ErikEJ, this does seem to contradict the comment by @kisantia here though: #93 (comment)

[ErikEJ]

@tomaustin700 This looks like a standard command timeout issue, and insufficient guidance on setting a long command timeout. What have you tried?

For tips and a commandline that sets correct timeouts, see my blog post here: https://erikej.github.io/efcore/sqldb/sqlpackage/2022/08/05/azuresql-sqlpackage.html

[tomaustin700]

Thanks @ErikEJ, I've added those timeouts to my script so I'll see if that helps. My first bit of troubleshooting let me to that statement about elastic pool limitation so I just wanted to see if it was something to be aware of or not before I moved any further with it. Thanks anyway.