Home:ALL Converter>Copy Table from Local Sql Database to Azure SQL Database

Copy Table from Local Sql Database to Azure SQL Database

Ask Time:2017-06-13T04:19:19         Author:raginggoat

Json Formatter

How can I go about copying a table from a local SQL database to an Azure SQL database nightly? Maybe I should use SSIS packages?

Author:raginggoat,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/44508062/copy-table-from-local-sql-database-to-azure-sql-database
David Browne - Microsoft :

Options (in rough order of preference):\n\n\nSQL Server Transactional Replication \nSSIS\nAzure Data Factory (especially for simple table copies)\nSQL Server Snapshot Replication\nLinked Server (INSERTs will be row-by-row)\nAzure Data Sync (still in preview)\n",
2017-06-12T22:02:18
4c74356b41 :

Looks like a good job for Azure SQL Data Sync.\n\nI won't copy paste the article here, but the main steps are:\n\nStep 1 - Create sync group\nStep 2 - Add sync members\nStep 3 - Configure sync group (here you can choose tables)\n\nThe link I've provided has the details",
2017-06-12T20:43:01
yy