Solved

Easy Sql question

Posted on 2004-10-28
219 Views
Last Modified: 2010-04-15
Hi experts!

I have a SQL database on a server machine.  I have some clients using MSDE that need a local copy of a big table.  Every day there are small changes to the big table.  What is the fastest way using c# to get the user's local copy in sync with the server copy?  

The table is about 200MB.  So I need to optimize the internet traffic as well.

Thanks!
0
Question by:OptionsMM
    5 Comments
     
    LVL 9

    Accepted Solution

    by:
    you could add a LastUpdated column to the table with a trigger that updates the field every time it's updated, and in your msde copy create a lookup table (TableUpdates for instance) that includes the table name and last successfull update time. only get the records that were updated after the last update in the TableUpdates table.
    0
     
    LVL 69

    Assisted Solution

    by:Éric Moreau
    See BOL for Replication
    0
     
    LVL 20

    Expert Comment

    by:TheAvenger
    Just make a replication between the servers. The problem is that you have to configure every local MSDE separaterly...
    0
     
    LVL 5

    Expert Comment

    by:Kelmen
    Can the replication be setup through a installation setup? like a .msi?
    0
     
    LVL 20

    Expert Comment

    by:TheAvenger
    I don't think so....
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    This article describes a simple method to resize a control at runtime.  It includes ready-to-use source code and a complete sample demonstration application.  We'll also talk about C# Extension Methods. Introduction In one of my applications…
    It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
    This video Micro Tutorial is the second in a two-part series that shows how to create and use custom scanning profiles in Nuance's PaperPort 14.5 (http://www.experts-exchange.com/articles/17490/). But the ability to create custom scanning profiles a…
    This video discusses moving either the default database or any database to a new volume.

    913 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now