I've seen lots of post about large tables that contain millions of rows but my table only contains 700 rows however there are hi-res images in a varbinary(max) column and the table itself is 2GB.  When I use SQLMW it just errors after about 4 hours.  I've tried a small batch (about 50GB) and that works. I then tried 1GB and it failed.  

What I'd like to know is there a limit or a better way to split the transfer up so it commits each row (instead of one large transaction)?  It could take me days to do this otherwise experimenting (which I don't have),

Thanks

Kelly

Hi Kelly,

Please check the below links which provides information on how to migrate large data to sql azure.
Also check the link which contains information on Azure SQL Database General Guidelines and Limitations.

https://social.msdn.microsoft.com/Forums/azure/en-US/03bfe15e-a541-4b13-910d-5d23d9900486/moving-large-tables-from-sql-to-azure?forum=ssdsgetstarted

https://social.msdn.microsoft.com/Forums/en-US/45612523-2d39-46d3-a7aa-3c619196b99a/data-migration-to-azure-table-storage?forum=windowsazuredata

https://msdn.microsoft.com/en-us/library/ee336245.aspx

Hope it helps.

Regards,
Sunil.HP

Hi Kelly,

Please check the below links which provides information on how to migrate large data to sql azure.
Also check the link which contains information on Azure SQL Database General Guidelines and Limitations.

https://social.msdn.microsoft.com/Forums/azure/en-US/03bfe15e-a541-4b13-910d-5d23d9900486/moving-large-tables-from-sql-to-azure?forum=ssdsgetstarted

https://social.msdn.microsoft.com/Forums/en-US/45612523-2d39-46d3-a7aa-3c619196b99a/data-migration-to-azure-table-storage?forum=windowsazuredata

https://msdn.microsoft.com/en-us/library/ee336245.aspx

Hope it helps.

Regards,
Sunil.HP

• Proposed as answer by Girish PrajwalMicrosoft contingent staff, Moderator 16 hours 55 minutes ago

Hi Kelly,

Please check the below links which provides information on how to migrate large data to sql azure.
Also check the link which contains information on Azure SQL Database General Guidelines and Limitations.

https://social.msdn.microsoft.com/Forums/azure/en-US/03bfe15e-a541-4b13-910d-5d23d9900486/moving-large-tables-from-sql-to-azure?forum=ssdsgetstarted

https://social.msdn.microsoft.com/Forums/en-US/45612523-2d39-46d3-a7aa-3c619196b99a/data-migration-to-azure-table-storage?forum=windowsazuredata

https://msdn.microsoft.com/en-us/library/ee336245.aspx

Hope it helps.

Regards,
Sunil.HP

• Proposed as answer by Girish PrajwalMicrosoft contingent staff, Moderator 17 hours 5 minutes ago

Hi Kelly,

Please check the below links which provides information on how to migrate large data to sql azure.
Also check the link which contains information on Azure SQL Database General Guidelines and Limitations.

https://social.msdn.microsoft.com/Forums/azure/en-US/03bfe15e-a541-4b13-910d-5d23d9900486/moving-large-tables-from-sql-to-azure?forum=ssdsgetstarted

https://social.msdn.microsoft.com/Forums/en-US/45612523-2d39-46d3-a7aa-3c619196b99a/data-migration-to-azure-table-storage?forum=windowsazuredata

https://msdn.microsoft.com/en-us/library/ee336245.aspx

Hope it helps.

Regards,
Sunil.HP

• Proposed as answer by Girish PrajwalMicrosoft contingent staff, Moderator Monday, July 06, 2015 2:12 PM

Hi Kelly,

Please check the below links which provides information on how to migrate large data to sql azure.
Also check the link which contains information on Azure SQL Database General Guidelines and Limitations.

https://social.msdn.microsoft.com/Forums/azure/en-US/03bfe15e-a541-4b13-910d-5d23d9900486/moving-large-tables-from-sql-to-azure?forum=ssdsgetstarted

https://social.msdn.microsoft.com/Forums/en-US/45612523-2d39-46d3-a7aa-3c619196b99a/data-migration-to-azure-table-storage?forum=windowsazuredata

https://msdn.microsoft.com/en-us/library/ee336245.aspx

Hope it helps.

Regards,
Sunil.HP

• Proposed as answer by Girish PrajwalMicrosoft contingent staff, Moderator Monday, July 06, 2015 2:12 PM

Hi Kelly,

Please check the below links which provides information on how to migrate large data to sql azure.
Also check the link which contains information on Azure SQL Database General Guidelines and Limitations.

https://social.msdn.microsoft.com/Forums/azure/en-US/03bfe15e-a541-4b13-910d-5d23d9900486/moving-large-tables-from-sql-to-azure?forum=ssdsgetstarted

https://social.msdn.microsoft.com/Forums/en-US/45612523-2d39-46d3-a7aa-3c619196b99a/data-migration-to-azure-table-storage?forum=windowsazuredata

https://msdn.microsoft.com/en-us/library/ee336245.aspx

Hope it helps.

Regards,
Sunil.HP

• Proposed as answer by Girish PrajwalMicrosoft contingent staff, Moderator Monday, July 06, 2015 2:12 PM
• Marked as answer by Girish PrajwalMicrosoft contingent staff, Moderator 21 hours 55 minutes ago

Hi Kelly,

Please check the below links which provides information on how to migrate large data to sql azure.
Also check the link which contains information on Azure SQL Database General Guidelines and Limitations.

https://social.msdn.microsoft.com/Forums/azure/en-US/03bfe15e-a541-4b13-910d-5d23d9900486/moving-large-tables-from-sql-to-azure?forum=ssdsgetstarted

https://social.msdn.microsoft.com/Forums/en-US/45612523-2d39-46d3-a7aa-3c619196b99a/data-migration-to-azure-table-storage?forum=windowsazuredata

https://msdn.microsoft.com/en-us/library/ee336245.aspx

Hope it helps.

Regards,
Sunil.HP

• Proposed as answer by Girish PrajwalMicrosoft contingent staff, Moderator Monday, July 06, 2015 2:12 PM
• Marked as answer by Girish PrajwalMicrosoft contingent staff, Moderator Friday, July 10, 2015 9:12 AM

Hi Kelly,

Please check the below links which provides information on how to migrate large data to sql azure.
Also check the link which contains information on Azure SQL Database General Guidelines and Limitations.

https://social.msdn.microsoft.com/Forums/azure/en-US/03bfe15e-a541-4b13-910d-5d23d9900486/moving-large-tables-from-sql-to-azure?forum=ssdsgetstarted

https://social.msdn.microsoft.com/Forums/en-US/45612523-2d39-46d3-a7aa-3c619196b99a/data-migration-to-azure-table-storage?forum=windowsazuredata

https://msdn.microsoft.com/en-us/library/ee336245.aspx

Hope it helps.

Regards,
Sunil.HP

• Proposed as answer by Girish PrajwalMicrosoft contingent staff, Moderator Monday, July 06, 2015 2:12 PM
• Marked as answer by Girish PrajwalMicrosoft contingent staff, Moderator Friday, July 10, 2015 9:12 AM