Unable to View Tables After Copying Database to Another Azure SQL Server

I tested this scenario in my environment using the 'Copy' option in the Azure SQL Database. I created a new server by replacing the existing SQL Server name. Both the server deployment and the database copy operation completed successfully, and I was able to view the tables and data in the copied database.

Steps I followed:

Open the existing SQL database in the Azure portal.

Click on the Copy option.

You will be redirected to the Review + Create page.

Specify the target server name, database name, and compute + storage settings.

Verify the details entered, then click Review + Create to initiate the copy operation.

Screenshot Reference:

After completion, the new server and database were successfully created, and I was able to access all tables and data without issues.

Screenshot Reference: