Unable to view tables after copying database to another Azure SQL Server
I have copied our database to another Azure SQL database, see the screenshot. However, when I access the database, I'm unable to view the tables. I can only view system tables. Can someone let me know any additional steps I need to make when copying an Azure SQL database to another Azure SQL Server please?
I would appear I can't login to the database now that I have moved/copied it over to a new Azure SQL Server, but I don't understand why?
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:
- Azure SQL Database Backups PITR & LTR
- Unable to view tables after copying database to another Azure SQL Server
- Join Tables from different databases in Azure SQL (SAAS)?
- How do you check the status of a SQL Import Export Operation in Azure?
- Azure Auto-Scale Database
- Materialized view in Marketing Performance DB in Azure SQL database
- Azure Cosmos DB Gremlin API via Synapse Link using the serverless SQL pool
- Unable to Authenticate JDBC Connection to Azure SQL DB from Databricks - Must Use Multi-Factor Authentication
- Reuse the same set of columns for different tables
- Unable to connect to new Azure Fabric SQL Database Error: Invalid object name 'sys.database_filestream_options'
- Same Table value selection from same clients
- How to Create an Azure Fabric Database to allow for SQL Authentication
- Connection string fails in migration when stored as variable in Azure pipeline
- How do I merge two Azure SQL data sources?
- Azure cannot access connection string stored in app service configuration
- List available PricingTiers for Azure SQL Database Resource
- Connect a WCF project with Azure SQL using Active Directory Service Principal authentication type returns ClientSecretCredential authentication failed
- Azure SQL Msg 45122: The specified max size is invalid
- How to configure a Python application to use a passwordless connection with a Azure SQL Database?
- How do I use a User-Assigned Managed Identity to run an SQL statement on Azure SQL Database?
- Entity Framework Core migrations fail in GitHub Actions
- How to drop all tables and reset an Azure SQL Database
- How to join 3 tables without duplicate columns?
- How do I link two tables of the same name across two Azure SQL Server databases?
- How to resolve 'Value cannot be null' error when using Azure Functions Core Tools?
- PowerBI get data from different tenant SQL database
- Add a grouping column to keep time entries together based on on its value, then repeat the id until the next value occurs
- How to verify if my Azure Functions app with EF Core is using obsolete SQL Server API
- How to generate EF Core migrations script when ConnectionString is only known after ARM template deployment?
- Is there a way to get the allocated storage data percentage metric from Azure SQL database resource for creating an alert?