Cross Database Quries migartion from SQL Server 2008 to Azure SQL Database

Question

I have a On-premise SQL Server 2008 sp1 Enterprise edition. I want to migrate the database to Azure SQL Database but there are some migration blockers.
One of them is cross database queries.
Do we have to change the queries before migration but SQL Server 2008 doesn't external tables which is supported in Azure SQL Database.
How can we solve Cross Database Migration Blockers?

Answer 1

Hey @Sarvesh Pandey ,
The steps for you to migrate would be :

1. create a similar table schema (of source db) in the database(querying one) and replace the cross db queries with the new tables created within database
2. Then migrate the databases as Azure SQL databases
3. update the newly created tables from normal to External tables to do cross queries