MSSQL将数据发送到azure [英] MSSQL send data to azure

问题描述

1）在插入新数据时，有没有办法自动让MSSQL 2012向Azure发送数据？这意味着，插入的每个新数据都会触发一些SQL脚本将数据发送到Azure ..它是否存在？



我想在这里搜索我的问题但是我不知道搜索它的正确单词。它是否称为复制？



2）如何为MSSQL插入运行Visual Studio脚本？



**有一项任务，并且非常考虑Google的任务关键字。

感谢有人可以提供正确的关键字来搜索这两件事



我尝试了什么：



我还没有尝试任何东西。这是一个没有代码的常见问题。

解决方案

如果您说您在本地服务器（或PC或VM）上有数据库并且还希望发送该数据到Azure上的数据库然后复制将是一个很好的起点。

这个博客暗示有一些事情要发生 - 现在公开预览的Azure SQL DB事务复制Microsoft Azure博客 [ ^ ]



同步将是研究的另一个主题，例如 - 开始使用SQL数据库中的数据同步 [ ^ ]

Hi,

1) Is there any way to automatically for MSSQL 2012 to send data to Azure when new data is insert? Which mean, every new data inserted will trigger some SQL Script to send the data to Azure too..is it exist?

I want to search for my question here but I don't know proper words for searching it. Does it call "Replication"?

2) And how about running Visual Studio script for MSSQL insertion?

** Got a task and quite thinking the keywords for the task to Google for it.
Appreciate if someone can give a correct keywords for searching these two things

What I have tried:

I'm not try anything yet. This is a general question without code.

解决方案

If you are saying that you have a database on a local server (or PC or VM) and also want that data sent to a database on Azure then "Replication" would be a good start point.
This blog implies that there are things to come - Transactional Replication to Azure SQL DB now in public preview | Microsoft Azure Blog[^]

"Synchronization" would be another topic to research e.g. - Getting started with SQL Databases Data Sync[^]

这篇关于MSSQL将数据发送到azure的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！