How to do disconnected database

  • I don't know that this is relly SQL replication but...

    I need to look into distributing disconnected copies of a SQL application. As this is a very data driven application, all the business logic is implemented in stored procedures and UDFs. As the back end to a system fronted by web services, XML databases and wireless devices, it works very well in a connected state.

    However, I need to explore a portable version, most likely using a fat client, that still retains all the database functionality. What are the possibilities for providing a disconnected version of the SQL application for a remote, fat client driven version of the system?

    ------------
    Buy the ticket, take the ride. -- Hunter S. Thompson

  • You can redistribute SQLExpress/MSDE for this purpose and use merge replication or custom scripts to make data synch up with a central server. The downside is limitations on size with MSDE/SQLExpress.

  • Thanks, Steve.

    Do you know if that would require per-seat licensing for each of the remote units?

    ------------
    Buy the ticket, take the ride. -- Hunter S. Thompson

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply