'Table data cannot be migrated, source table is empty' in Azure SQL migration wizard
I'm trying to use either the Azure Data Studio SQL Migration Wizard or the Azure SQL Database Offline Wizard to migrate local databases to Azure SQL databases.
My databases have tables that at times are empty, but both wizards are failing to migrate them because of this, which I don't understand:
Table data cannot be migrated, source table is empty.
It is essential the tables and their respective relationships aren't left behind as they are integral to the application! I've searched for solutions but can't find anything matching these error messages.
Can anyone please offer an explanation of why the wizards won't process empty tables, and if there's a workaround?
The solution was to avoid the migration wizard entirely and do the whole thing in SSMS. I don't believe this tool has been properly developed or tested given the number of issues people face with frozen progress that they get billed for.
By using the SSMS "Export Data Tier Application" functionality and saving as a .BACPAC file, I was then able to also use SSMS to connect to the destination server and "Import Data-tier Application".
Hint: If you do this, SQL Azure needs a high amount of computing power to get the job done. Therefore I commissioned the database as GEN5_80 (price is enormous per month, but you scale it back down in the Azure portal as soon as the job finishes). My 5GB database took about 10 minutes to migrate.
- Which of definitions of database schema is correct?
- How to get isolation level in EF for MSSQL?
- Generate SQL Create Scripts for existing tables with query
- Insert multiple rows WITHOUT repeating the "INSERT INTO ..." part of the statement?
- Index for two columns that will be used in an operation on where clause?
- How do you update a datetime field in a table every time another field in the same table gets updated?
- Pros & Cons of TRUNCATE vs DELETE FROM
- comparing and contrasting Sybase and SQL Server
- How does sql server choose values in an update statement where there are multiple options?
- How to disconnect all users in sql server except sa?
- Select Consecutive Numbers in SQL
- SQL Find consecutive numbers in groups
- Spring Quartz configuration for connecting MS SQL server
- The most elegant way to generate permutations in SQL server
- Check column has 'letter' or '-' then bring value from another column
- Reading child XML node from column
- Combine JSON objects from multiple rows into a single object
- Find all stored procedures that reference a specific column in some table
- Laravel 10 stopped working with SQL Server Database
- Using TransactionScope around a stored procedure with transaction in SQL Server 2014
- Entity storing it's status as a FK to a status table. Can I update the FK once the status changes?
- How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
- I need to replace old path's images to new path with the same image
- Format date as yyyy-mm-dd hh:mm:ss.000
- Does a foreign key automatically create an index?
- How do I select only the latest entry in a table for each group so each 'latest' is a single row?
- "The certificate chain was issued by an authority that is not trusted" when connecting DB in VM Role from Azure website
- Kafka Connect SqlServer Configuration (SSL)
- SQL-Server: Is there a SQL script that I can use to determine the progress of a SQL Server backup or restore process?
- TSQL Email Validation (without regex)