问题描述
我有2个数据库
1:ADB
2:BDB
ADB包含3个ADBTabe / more fields
BDB包含3个字段的BDBTabe
当记录插入& quot; ADB.ADBTabe& quot;然后工作应该从该ADB表中获取数据并插入BDB.BDBTable
那么请您提供如何管理所有这些事情的方法。 />
我需要实现sql server DB端吗?
我如何为此实现Windows /任何其他工作?
能不能给我一个合适的建议。
我尝试了什么:
我不知道我是新的方案
I have 2 Databases
1: ADB
2: BDB
ADB contains ADBTabe with 3/more fields
BDB contains BDBTabe with 3 fields fields
When the records inserted into "ADB.ADBTabe" then the job should be take data from that ADB table and insert into BDB.BDBTable
So could you please provide the approach that how to manage all these things.
What i have to implement sql server DB side?
How can i implement Windows / Any other job for this?
Could you please give me the proper suggestion.
What I have tried:
I have no idea about the scenario i am new
推荐答案
这篇关于如何创建将数据库表数据插入另一个数据库表的Windows服务。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!