Copy one database record to another database

you need to use elastic query for this.

Please check this link for more information -

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-query-overview

+1

Check out this blog to understand data transfer between two azure tables

https://intelequia.com/blog/post/735/query-and-transfer-data-between-azure-sql-databases

+1

You can open the SQL Database Server in your local SQL Management Studio,

Once open, compose and run SQL query as:

+1

Visit this:

https://stackoverflow.com/questions/6572754/sql-azure-copy-table-between-databases

https://azure.microsoft.com/en-in/blog/querying-remote-databases-in-azure-sql-db/

Hope it helps.

Thanks.

+2