Using Data-tier Application Framework on a single table

Question

I'm looking for a way thats faster/better than SSIS to transfer large amounts of data quickly and reliably between on-premises and SQL Azure.

Can these magical bacpac files only include a whole database, or can I just transfer a single table?

Transferring 10 million (very small) rows using SSIS takes like 8 hours. Not acceptable.

Thanks!

Answer 1

Hi Kevin,

 

Take a look:
http://social.msdn.microsoft.com/Forums/en-US/sqlazurelabssupport/thread/2094b424-4033-4f36-bc9a-9992d1be6120

Answer 2

Hey Kevin,

 

At this time, the import/export services will retrieve the entire database.  We will be adding support for selective exports prior to the final release.  Thanks!

Answer 3

Hi Kevin,

SQL Azure Data Sync CTP2 supports selected table Synchronization between SQL Server and SQL Azure and Vice Versa. Its available under limited CTP.

You can request for access from http://connect.microsoft.com/sqlazurectps

 

---

Arunraj Chandrasekaran, MCTS, Author: SQLXpertise.com
If you found this post useful, let us know by clicking "Vote as Helpful".