how to export data to sql uploaded in web
-
thanks guides. i want to transfer data from local sql to server sql without connect to internet in win application and i want transfer data in offline mode. please help me best regards
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.
-
thanks guides. i want to transfer data from local sql to server sql without connect to internet in win application and i want transfer data in offline mode. please help me best regards
OK, so if you don't have a connection between the client and the server, how are you going to get the data over there? Put it on a disk and give it to a kid with a good pair of shoes??
A guide to posting questions on CodeProject[^]
Dave Kreskowiak -
OK, so if you don't have a connection between the client and the server, how are you going to get the data over there? Put it on a disk and give it to a kid with a good pair of shoes??
A guide to posting questions on CodeProject[^]
Dave KreskowiakI believe it's called "Man in a Van".
-
I believe it's called "Man in a Van".
I was thinking of "SneakerNet" myself. :-D
A guide to posting questions on CodeProject[^]
Dave Kreskowiak -
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.
thanks guides i am low level please give me Further explanation about transfer data from sql local to sql . best regards
-
OK, so if you don't have a connection between the client and the server, how are you going to get the data over there? Put it on a disk and give it to a kid with a good pair of shoes??
A guide to posting questions on CodeProject[^]
Dave KreskowiakCarrier pigeons ;P
"I've seen more information on a frickin' sticky note!" - Dave Kreskowiak
-
thanks guides i am low level please give me Further explanation about transfer data from sql local to sql . best regards
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. Synchronizing between databases google search...[^] might be able to shed some light for you. Wish you the best of luck :)
"I've seen more information on a frickin' sticky note!" - Dave Kreskowiak
-
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. Synchronizing between databases google search...[^] might be able to shed some light for you. Wish you the best of luck :)
"I've seen more information on a frickin' sticky note!" - Dave Kreskowiak
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 ? best regards
-
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 ? best regards
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.
-
hi, i dont english good. i want in win application export data to table located in web sql in mode without connect internet.i will do export in offline mode. best regards
If both your servers are accessible from the same network that you're connected from then you can use sql import/export wizard
-
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 ? best regards
fatemehsoleimani wrote:
there are not methoad to transfer data in offline mode
No! As Pete and Dave have said, you need a network connection of some sort to have the two computer transfer information. Now, I am the THIRD person to say this. What part of it do you not understand?
fatemehsoleimani wrote:
sql server directly with export data might transfer data to server in offline
Only way would be through a removable disc media. This would entail writing the local database data to a file, and having some application on the server read this file.
"I've seen more information on a frickin' sticky note!" - Dave Kreskowiak
-
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.
He must be a slow learner.... Now that I've read your post, I pretty much rehashed what you said too :rolleyes:
"I've seen more information on a frickin' sticky note!" - Dave Kreskowiak
-
He must be a slow learner.... Now that I've read your post, I pretty much rehashed what you said too :rolleyes:
"I've seen more information on a frickin' sticky note!" - Dave Kreskowiak
Well, I awarded your answer 5 because it clearly showed him how to transfer data.
-
Well, I awarded your answer 5 because it clearly showed him how to transfer data.
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
-
fatemehsoleimani wrote:
there are not methoad to transfer data in offline mode
No! As Pete and Dave have said, you need a network connection of some sort to have the two computer transfer information. Now, I am the THIRD person to say this. What part of it do you not understand?
fatemehsoleimani wrote:
sql server directly with export data might transfer data to server in offline
Only way would be through a removable disc media. This would entail writing the local database data to a file, and having some application on the server read this file.
"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. best regards