Update record on the web using RDS

[mrsiva]

hi

I have a local Access Database where records are updated or new records inserted. I do not want to upload the whole database on the net but just the most recent and updated records. I taught I can use Remote Data Service, but my hosting company does not support it.

Please advice how do I go about to solve this problem.

I plan to eventually upgrade my database software within 6 months. I need to convert data from Access to either MySQL or Microsoft SQL. Any recommendations, which will require least asp and database changes.

Thank you in advance

[Xoc]

Easiest way is to just export the records that you want to a new database, then upload that database to the server, replacing the one that is up there.

There have been several discussions in the last week in this forum on the tradeoffs between Access, SQL Server, and MySQL. You might want to poke around, or search using the WebmasterWorld search function.

[mrsiva]

The problem is I cannot just upload the local database. There are visitors entering data on the web-hosting server and users entering data in the local host server. Hence the only choice I have is to merge database. I plan to use RDS to accomplish this task. But now I find the the web-hosting company does not support it. Infact now the dont even support sendmail.

[duckhunter]

You're asking an awful lot of Access and if you are switching, SQL Server definitely over MySQL for the DTS (Data Transfer Services) capabilities.

In a case like this where you have two physical database servers and problems managing things like OrderIDs or CustomerIDs that should be unique in a database model, you are going to have to rely on a GUID which is a randomly generated ID by the OS and it's algorithm takes some local computer variables into account when it creates it as to be globally unique (99.999999% unique).

Now you can apply the daily transaction logs from each server to each server and voila, replication complete. Get a high speed internet connection, setup the packages and SQL Server scheduled DTS will do it for you.