Hello Dhiraj,
If you wish to move the entire resource to a different subscription then you need to perform Data Migration. Please refer to this link for more details: https://docs.microsoft.com/en-us/azure/azure-resource-manager/resource-group-move-resources.
but if you want to copy then you'll have to take backup and
import into another subscription.
Export
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-export
Import
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-import
Hope that helps !
Regards,
Shubham Agarwal
