Is it possible to set up multiple Taskserver Servers and Replicate?
Great Example! I have been playing around with disconnected recordsets, but this just blows mine away.
Is it possible to set up multiple Taskserver Servers, and have them Replicate Back?
I need to develop an application that has the flexibility of being used Online or Offline, and for lager Installations (power User and Remote Multi User Lan) I need the data to be local.
I don’t think XML won’t cut it for a local store, so I thought about using MSDE with merge replication to a SQL 2000 box.
So:
1) Single Infrequent Users \ Mobile Users Attach Directly to Main SQL Server
2) Power users Attach to Local MSDE and Replicate Back to Main SQL Server
3) Multi User Remote LAN attach to Local MSDE\Full SQL Server and Replicate Back to Main SQL Server
Problems I see so far - Which might be resolved in next version of SQL
1) Replication in SQL isn’t XML, It’s still FTP snapshots which makes it difficult to Untrusted partners.
Anyone have anything \ Reason that it might not work?
Thanks,
Mike Pisano
