How to copy certain data from azure SQL database to another azure SQL database

See more:

SQL

If i have two azure sql databases.. One is called FROM and the other one is called TO

The from database has some certain things that i need to copy to the TO database

I created a new stored procedure
Where it has some selects using the FROM db and based on some conditions I need to insert values to the TO database tables

However it seems this is not supported. Even though it worked by copying from a local DB to another local DB

What I have tried:

Is it doable to copy the data and do some inserts using the stored procedure?