Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Location
    Tasmania
    Posts
    58

    Unanswered: Transfer of subset of data to/from notebook

    I have a need to dump a subset of a database from the server (SQL Server) to a notebook via the network, for data entry to be done on the notebook when it is in the field & not connected to the network & then the changes made to this data on the notebook to be applied to the database on the server.

    The application for the front end to this is in Access. Would MSDE be the way to go for the database on the notebook ?

    It's a small application with not many users, likelihood of conflicting edits is small.

    Would the data transfer best be done with replication or with DTS ?
    Presumably replication would allow options for control over conflicts, such as the same bit of data being changed on the server & on the notebook’s copy of the data ?

    I need guidance re direction to head in with this.

    Thanks
    catkins

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    IF you use Replication then ensure connection is available between these 2 notebooks when its schedule to replicate data.

    Using DTS is another option where you can schedule it as a job or invoke whenever the data must be updated.

    And to use DTS you must have server edition of SQL Server.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Dec 2003
    Location
    Tasmania
    Posts
    58
    Thanks for that.

    Does that mean using merge replication will be difficult to run on demand ? One couldn't bring the notebook back to the office & merge the changes from the notebook at any time ?

    Whereas a DTS process could be run whenever one felt inclined.

    Is DTS able to handle changes to data, if the data subset on the notebook could have fields edited, added or deleted ??
    catkins

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •