每天在asp.net Web应用程序中将记录从一个数据库插入另一个数据库. [英] Insert record from one database to another database on daily basis in asp.net webapplication.

问题描述

大家好

我正在asp.net Web应用程序中工作.我想在其中将记录从另一个数据库的表插入数据库的表中.我的要求是我希望它应该每天自动插入.因此，我认为可以通过使用Web服务来实现.但是我不知道该怎么办.

因此，如果有人有任何链接或与此相关的任何文章，请帮助我.

Hello Everyone

I am working in asp.net web application. In which i want to insert record in a table of my database from a table of another database. And My Requirement is that i want it should be automatically inserted on daily basis. so i assume that it can be accomplished by using web services. but how can i do it i have no idea.

so if anyone have any link or any article related to this please help me.

推荐答案

http://forums.asp.net/p/1364020/2826971.aspx [ ^ ]
http://databases.about.com/od/sqlserver/ss/sql_server_agent_3.htm [ ^ ]
http://www.dailycoding.com/Posts/step_by_step_guide_to_add_a_sql_job_in_sql_server_2005.aspx /<

http://msdn.microsoft.com/en-us/library/ms190268.aspx[^]
http://forums.asp.net/p/1364020/2826971.aspx[^]
http://databases.about.com/od/sqlserver/ss/sql_server_agent_3.htm[^]
http://www.dailycoding.com/Posts/step_by_step_guide_to_add_a_sql_job_in_sql_server_2005.aspx[^]

您可以通过在数据库.首先创建一个过程，将数据从一个数据库中的表传输到另一个数据库，然后创建作业，附加过程，然后计划每天的特定时间.据我所知，JOB计划可用于SQL Server和Oracle，未检查其他数据库.

you can do it by creating JOB in Database. First create a procedure to transfer data from tables in one database to other, and then create job, attach procedure and then schedule for particular time , for daily. To my knowledge JOB Scheduling is available for SQL Server and Oracle, other databases not checked.

这篇关于每天在asp.net Web应用程序中将记录从一个数据库插入另一个数据库.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！