Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dylancat
Starting Member
2 Posts |
 Posted - 2007-07-05 : 05:07:06
|
| HiThe situation is this. I have a desktop app which exports data to sql 2005 across internet. What is the most robust way of doing this and what security should be in place?I have heard that sending data across to sql is not the best & safest way, but unfortunately cannot really do anything about this. is there any way of getting over the problem if connection goes down while uploading, and is Bulk Insert the best method?Would appreciate any comments on "need to copy data to sql 2005 over internet in best way" if possible.Many thanksDylan |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-07-05 : 05:18:31
|
| "is there any way of getting over the problem if connection goes down while uploading"Put the new data into a Staging Table, perhaps with a column for "Batch Number" or somesuch and then once you know the data has uploaded completely to the Staging table call some process that actually transfers the data from Staging to the Live tables - and then deletes the data from Staging Table.Kristen |
 |
|
|
dylancat
Starting Member
2 Posts |
Posted - 2007-07-05 : 09:33:04
|
| HiMany thanks, very very helpful information KristenDylan |
|
|
|
|
|
|
inserting/exporting data from SQL over internet?