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
thanks for guide i am understand that i dont might transfer in offline.
i am need how to transfer data bulk in file in c#?
very very thanks for guide .
i am need example code for this do.
please frther guides me.
I checked the datasource (64 bit, the 32 bit doesn't seem to have a driver) and it looks ok. The only difference is the driver in the Data Sources says: "MySQL ODBC 5.2 Unicode Driver", but I tried that too (and the ANSI version as well).
I always receive the error: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
(Provider=MySQL Provider;Data Source=[servername];User ID=[usrname];Password=[pwd];Initial Catalog=[dbname];) The driver is "activated".
The parameters I pass are correct and MySQL Workbench is working as well as the ODBC connection.
The code is pretty robust by know and PostgreSQL ODBC works, so I'm pretty sure it's not the code (although you never know.)
Does anyone have an idea?
My mistake, I was under the impression that the provider installed OleDb support, but in fact it installs an entire new provider (MySql provider). When interfaced with that it looks like it's working.
can someone help me with finding complete information about the printer that is connected to the network (number of pages printed ,number of pages copied by whom and at what time). My network setup, there is a print server ,2 network printers on the network.
I m new to programming and I need to submit this project ASAP
i dont english good .i will import data from excel to c# win application and transfer data to sql. but i can't .i will import data from excel(some columnsnot all) to grid and insert bulk to sql .i am low level .please help .
Last Visit: 31-Dec-99 19:00 Last Update: 3-Mar-24 8:48