hey, i have an idea here but i dunno how to put it into picture
i'm thinking of creating a WINFORM APPS to extrct files from my database in my local machine (msde) and transfer it to a remote server online (sql2000). so wat are the options i can use to do this?
what i've thought so far is storing the local data (through query: sql specific) in an xml file through DOM manipulation then uploading to the remote server using ADO (not sure abot ado.net coz not familiar with saving bulk record with that)
any idea on what other way that i can take advantage using .NET framework?
the idea of this app is to have the remote server (which resides on the internet) to act as a central repository for the files being transfered into it.
btw, this will be entirely done on WINFORMS
what are the considerations when you want to connect to a sqlserver2000 which is remotely situated from my local area network?
my concern in this matter is mainly whether how can i handle disconnection from the server when the process is in progress and how do i upload the data (from local to remote) by using which method most effectively
i'm thinking of creating a WINFORM APPS to extrct files from my database in my local machine (msde) and transfer it to a remote server online (sql2000). so wat are the options i can use to do this?
what i've thought so far is storing the local data (through query: sql specific) in an xml file through DOM manipulation then uploading to the remote server using ADO (not sure abot ado.net coz not familiar with saving bulk record with that)
any idea on what other way that i can take advantage using .NET framework?
the idea of this app is to have the remote server (which resides on the internet) to act as a central repository for the files being transfered into it.
btw, this will be entirely done on WINFORMS
what are the considerations when you want to connect to a sqlserver2000 which is remotely situated from my local area network?
my concern in this matter is mainly whether how can i handle disconnection from the server when the process is in progress and how do i upload the data (from local to remote) by using which method most effectively
