import database from bacpac
Using bacpac dows not import any database but create a new database.
It may seem like I'm petty about using the right terms but there's a big implication in understanding the meaning, since importing database suggest that you get the same database as your source (as you get when using database backup and restore), but this is far from being true when using bacpac.
In fact, this directly related to your question :-)
I need to import a DB from bacpac (created on another server on another subscription in Azure) to set up a dev test DB on my server in my subscription.
If you need to create a copy of the database and both the source and the target database are Azure SQL Database then you should use
CREATE DATABASE... AS COPY OF
Import completed successfully, without errors in logs, but system versioned tables are not there.
This can be a result of using old version of SSMS or more accurate old version of the utility SqlPackage.exe
Update the version of the SSMS and use the latest version.
Note! You might have multiple versions of SqlPackage.exe so you need to make sure you use the newer one.
If you need to create a copy of the database and both the source and the target database are Azure SQL Database
This doesn't work between different subscriptions, unless I don't know something that happened recently?
You can use CREATE DATABASE... AS COPY OF with different subscriptions if you have matching logins in the different subs.
see --> https://learn.microsoft.com/en-us/azure/azure-sql/database/database-copy?tabs=azure-powershell#copy-to-a-different-subscription
By the way, if you do not have such login then you simply create one :-)