Data Updation Local to Remote on SQL 7

[Cap2010]

Have 2 SQL Servers 7.0
One Local and the other Two Remote(in another states/country)

Creating an ASP Application,
where the user inputs data to Local SQL Server and
the same data will be uploaded to remote server at
a stretch one time on connecting to internet.

The Remote server is accessed by the internet user through web, for data entry 24 hours a day.

Question is
How do I update the remote server with local new data, at a stretch directly, without affecting the online process and at the same time, synchronize the remote data with new data uploaded through local database and data entered same time somewhere on through internet users using web pages created to enter records.

Every new entry gets new id and has several updation connected to the tables.

Don't want duplication of records through ID's and no clashing of records with total database security.

Thanks,

Lad

 

[Qaroven]

Look up Publish/Subscribe in SQLBOL ..
Also have a 'central' DB which issues the ID field numbers (transactions, etc ..) Ben
+61 403 395 052

 

[Cap2010]

Qaroven,

Haven't understood your statement.

Thanks,

Lad

 

[SethS25]

Lad -

Did you ever get a response to this. I have to tackle the excact same task and any help would be much appreciated.

Seth

 

[Cap2010]

seth,

Not in much of response. Let me know from you.

Thanks,

lad

 

[funtus]

hi,

I am also looking help on this....

i found some resource of help (but have to be modified):

http://www.a1vbcode.com/snippet.asp?ID=320

software like :

http://www.lockwoodtech.com/sqldiff.htm

..............................

The last positng was very old if any guys found any solution inform me plz...