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 - 2005-08-31 : 07:41:17
|
| Vipin writes "This question for my current project regarding replication i realy new to sql server DBA ,this project about MLM ,in this they want weekly procssing for calculating each members income in their current postion in 'network'(4 matix tree style),, after processing they want take income statements for each userand also they provide income statement to each members through thier web site with member loginbut they only accept online registration through their web site ,'Weekly proccesing' that i said will take minimum 1 hour ,so i decide to implement merge replication ,but went through web i didn't get clear solution , normaly i connect sql server in web hosting meachine through Client Network Utility with TCP/IP protocol ,i decide to configre local meachine's sql server instance as publisher and distributer ,web hosting meachine's as subscriber using merge replication with push subscription, please tel how i can implement this solution i have no idea about this so tel with example, steps and also requrements what is your opinion about this solution,if it is bad solution or there other better solution and also tel how i can apply this too." |
|
|
|
|
|
|
|
Merge replication with push subscription