Hi
I am in the early stages of planning a SSL website that will allow clients to login and retrieve small amounts of information, and to update some information.
Our local database will hold most of the data, and the remote webserver database will hold only the necessary fields.
The data in each database will need to be merged/sync'ed regularly (perhaps every hour) to keep both up-to-date, but to save bandwidth only updated data will need to be tranmitted.
Confidentially/security is our main concern.
Our local database is an SQL Server 2k DB which will handle encryption and syncronisation over the internet with another 2kDB, but I am not able to find a webhost that will support me doing this (for a reasonable price). Also we are based in the UK and because of new Data Protection laws hosting this data outside the EU could cause issues.
Could anyone suggest better methods that could be used to keep this data in sync whilst still keeping security to the highest level.
Thanks
I am in the early stages of planning a SSL website that will allow clients to login and retrieve small amounts of information, and to update some information.
Our local database will hold most of the data, and the remote webserver database will hold only the necessary fields.
The data in each database will need to be merged/sync'ed regularly (perhaps every hour) to keep both up-to-date, but to save bandwidth only updated data will need to be tranmitted.
Confidentially/security is our main concern.
Our local database is an SQL Server 2k DB which will handle encryption and syncronisation over the internet with another 2kDB, but I am not able to find a webhost that will support me doing this (for a reasonable price). Also we are based in the UK and because of new Data Protection laws hosting this data outside the EU could cause issues.
Could anyone suggest better methods that could be used to keep this data in sync whilst still keeping security to the highest level.
Thanks
