Reference is not allowed when refrencing 2 databases

Question

I have a databse ACB referencing from 2 databases.

When I try to create BACPAC file I have this error : Reference is not Allowed

How can I resplve it ?

Answer 1

I really don't understand the need to reference two databases since all the databases are gathered under one logical server.

Check this old thread : https://stackoverflow.com/questions/45707120/microsoft-azure-sql

Answer 2

Hi Sasha Sasha •

For an export operation its recommended not to export bacpac from an active database, it does not guarantee transactional consistency.

You can first copy it to a new database and use this database as the source of export - See this URL for more reference Copy a database - Azure SQL Database | Microsoft Docs. Hopefully this should resolve reference related errors.

Thank you!

Answer 3

Hm, I what are you trying to do?

Do you have three-part references like:

SELECT * FROM thatdb.dbo.thattable

You cannot do this in Azure SQL Database. The databases may be on the same logical server, but physically they can be located in different regions in different parts of the world.

If you want to make cross-databases references you can set up external tables or you can use sp_execute_remote to run queries in the other database.