I'm in the process of writing an app using the MM framework that will eventually be distributed to nine different locations. The app. needs to be able to be run even if our WAN is down (or not available). That kind of limits us to using local data and replicating information for corp. use. That's fine for analysis but we've found that we really need two-way replication so changes to the data get sent back to the remote locations.

One way replication is relatively easy. Two way gets much hairier. I've been thinking (with all this talk of it lately) MSDE might be a good fit. I'd run SQL Server at the corp level as the replication master then MSDE at the remote locations. The 5-concurrent users "limit" there isn't a problem.

Obviously I could upsize the application and use remote views. But, I'm sure when I try to optimized operations I'll want to move towards stored procedures.

I think it'd be nice to be able to associate a stored procedure with my "lookup" views (probably via the bizobj builder). If there is a SP associated with the view have MM's use that instead of the local/remote view. This would allow my app. to continue to work even though I'm not using local or remote views plus give me some of the advantages of SP's.

Has anyone tried anything like this? Or, does anyone have any other ideas on how something like this should work?