Choosing between Databases in an Application RRS feed

  • Question

  • Hi,

    I am using two servers for my Application. One Sql Server(data prvider for Sql Server)  and one Sql Server Compact 3.5.
    The two databases have exactly the same structure and data,  being synchronized periodically.
    I want my users to be able to choose if they want to go online (use the main server) or work offline (Sql Server Compact) each time they login.

    I want to assign the main Dataset to one of these servers based on the user's choice.

    Can somebody help me? 

    Tuesday, October 20, 2009 10:29 AM


All replies