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 |
|
matt_calhoon
Posting Yak Master
235 Posts |
 Posted - 2001-08-20 : 01:24:50
|
| Hi there,Im looking on ideas for this scenario..I have a SQL 7.0 db that resides on a web server. This database grabs info from web users who update account information. This database gets exported as a delminated file to a clients local system for import into their offline database and updating of records.The online database on the server also needs to import a deleminated data file from the local database on a daily basis.So you can see I have a scenario with 2 way replication. What would be the best way to achieve this so that only the latest data gets updated on either server? would I use a timestamp and the identity column to distinguish which update has priority?Any ideas on the best solution would be appreciated.thanks - matt |
|
|
|
|
|
Replication to a deleminated text file