我想使用sql 2005将Recods从一个服务器数据库表提取到另一服务器示例本地服务器数据库表 [英] I wants to fetch the recods from one server database table to other server example local server data base table using sql 2005
问题描述
我想使用sql 2005从一个服务器数据库表中获取记录到另一个服务器示例本地服务器数据库表中，并且还提供在任何新记录中的条件是在服务器表中再次添加，然后在一段时间后我们的本地表也插入了该新记录，并避免插入重复的记录
请举例说明一个可能的情况，然后发送发送一个小项目
我无法理解(在我们的系统上)说了以下三个答案
谁能说出如何达到这个概率的口香糖解决方案
Thaks
I wants to fetch the recods from one server database table to other server example local server data base table using sql 2005 and also provide the condition in any new records is add again in server table then after some time our local table also insert that new records and also avoid insert duplicate records
Explain withe one example inf possible then plaz send send the one little project
i am not able to understand (on our system)wat say three answer given below
can any one tell how to achive the gud solution of this prob
Thaks
推荐答案
请说明一个示例，然后再发送发送一个小项目
Explain withe one example inf possible then plaz send send the one little project
如果您想提出要求，则应该去求职委员会并愿意付钱给某人.
就像在同一台DB服务器上一样进行操作，只需要两个连接字符串，然后使用列出的条件编写代码以从一个数据库读取数据，然后将其插入另一个数据库.除了需要自己完成工作之外，在不了解数据库架构的情况下也无法为您提供准确的代码.
顺便说一句，我删除了重复的问题.
If you want to give demands, you should go to the job board and offer to pay someone.
You do this the same as if they were on the same DB server, you just need two connection strings, then code to read the data from one, and code to insert it into the other, applying the conditions that you''ve listed. Apart from the fact that you need to do your own work, it''s not possible to give you exact code without knowing your DB schema.
BTW I deleted your duplicate question.
您可能想看看
如果是我我" d创建计划以合理间隔运行的SSIS服务器软件包.
您可以镜像数据库
查看SQL Books On Line中的数据发布.
备份数据库并还原到其他数据库
如果表不是太大，则根据记录不在目标表中而使用异质查询
发挥创意.
使用合并.
查找有关更新断开连接的数据库的文档. .Net文档涵盖了这一点.
我覆盖了吗?If it was me I''d create an SSIS server package scheduled to run at a reasonable interval.
You could mirror the databases
Look at data publishing in SQL Books On Line.
Backup the database and restore to the other
If the tables are not too big use an hetrogenous query based on the records not being in the destination table
Get creative.
Use merges.
Look up documentation on updating disconnected databases. .Net docs cover this.
Have I covered it ?
这篇关于我想使用sql 2005将Recods从一个服务器数据库表提取到另一服务器示例本地服务器数据库表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
