The Lounge isn't for programming questions rather than isn't for code: it's for talking rather than coding if you like. If it's a discussion about how it amuses you, then that's fine. If it's about how it works, or how to fix it, then that's a no-no.
This forum is for code - though talking does go on - it's deliberately more technical here.
Never underestimate the power of stupid things in large numbers --- Serious Sam
In order to upload the data you have to connect to the database server. There are many ways you can do this. You could use a web service, or you could open a direct connection to that database and fire your commands directly. If, you are talking about exporting the data at the server side, then as long as you have uploaded it, you may not need an active connection at that end. Depending on what database you are using, you should be able to schedule a task that runs at the database server that exports the data.
The key thing is - you don't need to be connected to export data that exists at the client side. You only need the connection to get the data from the client to the server or to get data from the server to the client.
I'm not sure how many different ways I can say the same thing. If you want to transfer between two different servers, you have to have an active connection. It doesn't have to be a web based connection, but you do need to have a Sql connection to the remote database server, as long as that server is configured to allow you to connect directly to it.
If you mean "low level" such as being a beginner, this might be a bit of a task. Assuming that the two databases contain the same schema, you would want to just copy the data tables from the local sql database to the non local data tables while not conflicting with any referential integrity. It is a pretty trivial task if it is planned out and designed carefully.
thanks for guides with use intelligent service in c# might transfer data from local to server in offline?
there are not methoad to transfer data in offline mode?
with in sql server directly with export data might transfer data to server in offline ?
How many times can we tell you this? There are NO ways to transfer the data offline other than to copy the data out to storage like a USB drive and physically carry the device to the remote computer, plug it in there, and upload it from there.
Now, it is a matter of whether or not he could implement such a tool if he really needs to do offline transfers of data through USB or removable media. I can only imagine the fun in doing version control on the records being transferred between the databases. Time stamping the rows, dealing with locks on both ends, etc.
"I've seen more information on a frickin' sticky note!" - Dave Kreskowiak
Last Visit: 31-Dec-99 18:00 Last Update: 30-Sep-23 3:10