On Wed, 5 Jun 2002 08:47:18 -0700, Avi Nahir <[EMAIL PROTECTED]> wrote: >But if I don't install Access (or that free SQL Server I always keep >forgetting its name), how do I do replication?
So I would install another database server (if you can justify this cost) which uses one way replication from your main SQL database server. All reporting queries go to this replicated server and if you want to avoid repeatedly requesting the same data for a given workstation, then simply write the dataset onto the local workstation as an XML file. Subsequent (simple) variations of the previous queries can then use this local XML file, or go back to the reporting server for a different query. That's what I'd do anyway. :-) Hope it goes well, Lee. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
