Last post Sep 06, 2015 02:58 AM by Weibo Zhang
Sep 02, 2015 01:51 PM|Fresherss|LINK
I am making application that transfer data FROM 2008(LOCAL) TO 2000 (REMOTE).
PLZ SUGGEST ME HOW IT IS POSSSIBLE?
Sep 02, 2015 02:06 PM|gerrylowry|LINK
(a) do you own both servers?
(b) is this a one time transfer?
more information from you would help answer this question.
(1) from the local server, RDP to the remote server; copy and paste the .mdf file.
(2) create a web service on the remote server and pass the data a tuple at a time.
Sep 02, 2015 02:09 PM|Fresherss|LINK
hi @gerrylowry ,
thanks for the reply.
I own both server.
and this is not one time transfer.
it will run in every five minutes.
and both server connected on lan
Sep 02, 2015 06:34 PM|gerrylowry|LINK
because your question is so generic, and because you have provided so little information, please try this:
Do investigate Entity Framework.
Note: to run it every five minutes, you could host your code in a Windows service.
https://msdn.microsoft.com/en-us/library/zt39148a(v=vs.110).aspx "Walkthrough: Creating a Windows Service Application in the Component Designer" .NET Framework 4.6 and 4.5
Sep 03, 2015 01:17 AM|PaulTheSmith|LINK
Open connection to one database. Read the data.
Open connection to the other database. Write the data.
Sep 06, 2015 02:58 AM|Weibo Zhang|LINK
As supplementary, if you want to achieve the DataBase Synchronization by using C#, I think the
SqlBulkCopy would be very useful to you. It could help you copy the data from one data source to the SQL SERVER database faster. For more things, you could have a look at the following article. Every time you copy data, you need to use "where" judgment
to determine what you want to copy. About the “it will run in every five minutes.”, you’d better refer to
gerrylowry’s suggestion to implement it. Besides, in addition to synchronizing data by coding, you could also use
the SQL tools to achieve it.
I hope it’s useful to you.