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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-10 : 15:23:31
|
| Jason Jasinek writes "I might have a tough one for you.I am faced with a situation of building a banner ad management application which needs to be administered at a MAIN SQL server and then replicated to two remote servers (REMOTE1 and REMOTE2). In this banner ad management application I am keeping track of impressions and clicks for each banner, along with expiration states such as maximum clicks/impressions. This will be administered at the MAIN db and then replicated to each REMOTE db. Each REMOTE server is then updated via IIS whenever a banner is requested.This is rather easy, but here is where my problem comes in. Say we have BannerX at REMOTE1 that gets 45 impressions on 10/8/01 and BannerX at REMOTE2 that gets 25 impressions on 10/8/01. I need to let MAIN know about each REMOTE's stats (impressions and clicks) and report this back to each REMOTE server. Thus MAIN will calculate that BannerX had a total of 70 impressions on 10/8/01 and will update REMOTE1 and REMOTE2 to the correct amount of impressions. How can I do this with DTS.Other things I have noticed that could be a potential problem...1. When data is sent back to REMOTE1 or REMOTE2 their stats have incremented. ie... when MAIN updates REMOTE1 to 70 impressions REMOTE1 has actually recieved 49 impressions and the total for all should be 74 not 70.2. Data is recieved from REMOTES but when MAIN tries to update REMOTES one or both are down. When they come back up they need to be updated correctly. Might cause problem with caculation of hits.Any help would be greaty appreciated." |
|
|
|
|
|
SQL Server DTS / Replication to remote servers