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 |
|
victor514
Starting Member
1 Post |
 Posted - 2009-05-06 : 15:09:44
|
| Hi,I have a problem with replication. An application send to outside reps uses SQL xpress to sync with the main database server SQL 2K5.The problem lies with how the SQLCMD scripts were written on the server. Scheduled every night, the database ( let's call it A ) gets dropped and then recreated with new data from database B. The scripts also drop the distributor, publisher and all subscriptions. It then recreates the data, user accounts on the server, publishers, snapshots. Every time the reps login and synchronize their application they retrieve all data pertaining to their user account if their snapshots are not up to date. I've calculated the data dump and transformation process takes 6 hours and the publication/subscription creation process for all users takes another 6 hours. I need suggestions on how I can speed up this process please. My brainstorms:1. Update the tables during the day ( by dropping and reimporting ) and just reinitialize the publication snapshots every night. Still takes 6 hours at night and users are downloading full snapshots of data every time. 2. Update the transaction tables with only the latest day's transaction and change from being a snapshot replication to merge replication. Eliminate the recreation of publications for all users. Just reinitialize them, would it be faster?Suggestions? |
|
|
|
|
|
Need help figuring out replication