离线到在线数据传输 [英] Offline to Online Data Transfer

问题描述

你好，

我想每天在一天结束时将所选数据库的所选表中的数据从本地SQL Server上传到远程SQL Server..
请提出合适的解决方案.

谢谢和问候.

Deepak

Hello,

I want to Upload Data from Selected tables of a selected database to Remote SQL Server from Local SQL Server daily at the end of the Day..
Please suggest a suitable solution.

Thanks and Regards.

Deepak

推荐答案

您可以使用(无顺序)之类的工具:
-导出导入向导 [ bcp [链接的服务器 [ SSIS [

You could use tools like (in no order):
- Export Import Wizard[^]
- bcp[^]
- create a linked server[^] and transfer the data using for example a custom procedure
- use SSIS[^]

The list isn''t complete but gives some possibilities.

这篇关于离线到在线数据传输的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！