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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-08-25 : 08:56:24
|
| Darren writes "I've created an SQL Server database on my local machine for an online ordering system. I have created a DTS to delete all rows in a ProductsSKUs table and repopulate it from a .csv file every 10 mins with 'rollback' to previous state on error. This is so i can get data from an old dos based warehousing system. So far so good - seems to work fine.I have an identical structure database used as a back end to an online ordering system hosted at a remote location by my internet Service provider.I have used the client network utility to create an alias of the remote database on my local machine and am able to upload tables using the DTS by deleting the remote table and replacing it with a new one. The problem with this is that anyone accessing the web site while this procedure takes place will be told that no products are available.As i plan to automate this process every 10 mins or so via ADSL (for nearly real time stock levels) this will be quite a problem.So the question is how to insert, delete and update records as required so that it does not delete the whole table to do so?Have I missed the magic "update table" button or is it a more complex procedure?Many thanksDarren" |
|
|
|
|
|
Updating remote table data