Hi @Shannu D , welcome to Microsoft Q&A forum and apologies for delayed response.
Yes we can move the Azure SQL Databases across the subscriptions. We have an option of moving it as mentioned in below screenshot. I am assuming both the subscriptions are integrated with same Azure Active Directory, so the users would be able to authenticate it without any issues.
Referenced Article: How to move Azure SQL server to another subscription
Please let us know if this helps or else we can discuss further on the same.
----------
Please don't forgot to click on accept it as answer button wherever the information provided helps you. This can be beneficial to other community members as well.