Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    Location
    Canada
    Posts
    45

    Wink Unanswered: merge replication Sql server 2000 with SQLCE 2.0

    I do a merge replication between Sql server 2000 and SQLCE 2.0

    On my SQL2000 I have 4 tables i want to merge (specific columns only ) in 1 table for Merge with my SQLCe ( the table will be use for read only)

    Question 1:
    What is the best pratice for keep the information update?
    Run store procedure before the synch for re-populate the table? or Make Trigger INSERT, UPDATE, DELETE in the all 4 table? or a mixte?

    Question 2:
    Does someone know about some web site talk about this type of trick?

    Thanks
    Franky
    FBoucheros@hotmail.com

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    May refer to this link http://msdn.microsoft.com/library/en...chitecture.asp which lists from SQL SErver CE books online.

    http://csaw.biz/tips/sql-server-ce.php about KBAs with refers to CE.
    http://www.winnetmag.com/SQLServer/A...9004/9004.html
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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