The problem is a
A database, called student, he is a native SQLSERVER2000 database, there are a lot of data table, there are many records,
On the remote server has a same structure of the database called student
So how can I make a program will data uploaded to the remote server is not bad,
Also due to the local database will be updated constantly, so I want timing or hand to run the program to the new recorded appended to the remote
Server
Please advice
CodePudding user response:
With two transaction respectively connected to the database, and then read out the contents of a table, insert/update on remote servers table content. The field can be added to the local database record new insert/update data, according to the need for the corresponding operation.CodePudding user response:
With two transaction respectively connected to the database, and then read out the contents of a table, insert/update on remote servers table content. The field can be added to the local database record new insert/update data, according to the need for the corresponding operation.CodePudding user response:
Can beDo a data window and data source for remote database
Then the local student table to generate a datastore, will be given a piece of a recent data window, update!
So can't check duplicate rows, is looking directly in the
Another is that writing process directly, to follow your process, remote database can use alluding to come here
CodePudding user response:
Can also use the link to the server, and then like a server operation data between different libraries:Insert into table1 (... ) select... The from remoteserver. Db. Dbo. Table2;
About the link server use, please refer to:
http://topic.csdn.net/t/20061212/11/5224107.html
CodePudding user response:
Can also use the link to the server, and then like a server operation data between different libraries:Insert into table1 (... ) select... The from remoteserver. Db. Dbo. Table2;
About the link server use, please refer to:
http://topic.csdn.net/t/20061212/11/5224107.html
CodePudding user response:
Dizzy, CSDN can appear such problem:"/" in the application server error,
Unable to connect to, because the target machine actively refused,
Note: during the execution of the current Web request, an unhandled exception, please check the stack trace, to learn about the errors and mistakes in the code of the source of detailed information,
Exception details: System.Net.Sockets.SocketException: because the target machine actively refused, unable to connect,
The error source:
During the execution of the current Web request generated an unhandled exception, you can use the exception stack trace below to determine the reason and the location of the abnormal information,
The stack trace:
[SocketException x274d (0) : because the target machine actively refused, unable to connect,]
System. The Runtime, Remoting Proxies. RealProxy. HandleReturnMessage (called IMessage -- reqMsg, called IMessage -- retMsg) + 1734594
System. The Runtime, Remoting Proxies. RealProxy. PrivateInvoke (MessageData& MsgData, Int32 type) + 826
CSDN.Com munity. TopicFileDataCenter. TopicFileComponent. Reply (ReplyGenerateData RGD) + 0
CSDN.Com munity. TopicFileDataCenter. TopicFileDataCenterEntry. Reply (Guid topicId, DateTime createDate, ReplyInfo Reply, CommunityUser user, UserSectionProfile usp) + 73
CSDN.Com munity. PointForum. Services. ReplyTopicManager. ReplyTopic (ReplyInfo reply, DateTime topicPostDate, String& ErrorInfo, CommunityUser user, UserSectionProfile usp) + 692
CSDN.Com munity. PointForum. WebControls. ReplyTopicPage. Bt_Submit_Click (Object sender, EventArgs e) + 225
System. Web. UI. WebControls. Button. The OnClick (EventArgs e) + 105
System. Web. UI. WebControls. Button. RaisePostBackEvent (String eventArgument) + 107
System. Web. UI. WebControls. Button. System. Web. UI. IPostBackEventHandler. RaisePostBackEvent (String eventArgument) + 7
System. Web. UI. Page. RaisePostBackEvent (IPostBackEventHandler sourceControl, String eventArgument) + 11
System. Web. UI. Page. RaisePostBackEvent (NameValueCollection postData) + 33
System. Web. UI. Page. ProcessRequestMain (Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint