如何自动化传输数据的工作流程？

My machine is situated on Domain A. The main database for my system resides on Domain B. To get some data from the database, I do the following:

我的机器位于域A.我的系统的主数据库驻留在域B.要从数据库获取一些数据,我执行以下操作:

Initiate a remote desktop connection to a machine in Domain B

启动与域B中的计算机的远程桌面连接

Use a SQL query to dump data locally on the machine in Domain B

使用SQL查询在域B中的计算机上本地转储数据

Mount my local drive onto the machine in Domain B and copy the generated files

将我的本地驱动器挂载到域B中的计算机上并复制生成的文件

Import the data into my local database on my machine in Domain A

将数据导入到域A中的计算机上的本地数据库中

While I don't really have a problem with this, I am finding myself do the same thing over and over again and am looking for a way to automate this. Unfortunately, the remote machine in Domain B logs me out after a period of inactivity of 15 minutes so I cannot mount my drive and copy the data directly onto it. My goal is this:

虽然我真的没有这个问题,但我发现自己一遍又一遍地做同样的事情,我正在寻找一种自动化方法。不幸的是,域B中的远程计算机在一段15分钟的不活动时间后将我注销,因此我无法安装驱动器并将数据直接复制到其上。我的目标是:

Be able to transfer data from the database in Domain B into the database I have setup locally in Domain A.

能够将数据从域B中的数据库传输到我在域A中本地设置的数据库中。

Is there anyway to automate (or at least partially automate) this tedious process? All I want to do is to mirror some data from the remote database but the whole import/export process is sucking the energy out of me because I always face some or the other import errors. Any suggestions?

反正是否有自动化(或至少部分自动化)这个繁琐的过程?我想做的就是从远程数据库镜像一些数据,但整个导入/导出过程正在吸取我的能量,因为我总是面临一些或其他导入错误。有什么建议么?

EDIT: I only have read-access to the databases in Domain B. The machine in Domain B can pull data from other linked server as well situated in the same domain.

编辑:我只对域B中的数据库具有读访问权限。域B中的计算机可以从位于同一域中的其他链接服务器提取数据。

3 个解决方案

#1

Why not build an SSIS package that you can execute that will pull the data from Domain B and plug it into the database on Domain A?

为什么不构建一个可以执行的SSIS包来从域B中提取数据并将其插入到域A的数据库中?

#2

Since you are able to mount the disk of machine at Domain A to machine at Domain B, I suppose you are able to connect from A to B?

由于您可以将域A的机器磁盘安装到域B的机器上,我想您可以从A连接到B?

In that case, how about doing a remote SQL connection to domain B from domain A? Then you could dump data straight to your local disk and import to database.

在这种情况下,如何从域A进行到域B的远程SQL连接?然后,您可以将数据直接转储到本地磁盘并导入到数据库。

#3

You should be able to automate many of these steps using Automation Anywhere. By using either the recorder or the editor, you can set up these steps and then run them anytime with the scheduler. Affordable as well. Hope this helps. Tom

您应该能够使用Automation Anywhere自动执行其中的许多步骤。通过使用记录器或编辑器,您可以设置这些步骤,然后随时使用调度程序运行它们。价格实惠。希望这可以帮助。汤姆

#1