SQL Server Performance

Linked Servers and automatic updates

Discussion in 'SQL Server DTS-Related Questions' started by simflex, Jun 13, 2007.

  1. simflex New Member

    Greetings experts:

    We have 2 databases running same server.

    Let's call them database1 and database2.

    A job was scheduled to extract data from database1 into database2 3 times a day.

    This works fine.

    Now, we have been asked to set up another job that will extract data, this time, from database2 into MS Access database.

    I decided that setting up a linked server will be the easiest way to go about this.

    I have set this up succeessfully.

    We still want data extracted from database1 to database2 3 times daily, just like it is right now.

    My questions, once data is extracted from database1 to database2, does that automatically update the linkedserver?

    Thanks a lot in advance.
  2. nareshb New Member

    what I feel is 'yes'...linked server will give you the updated data. It should be same as using database2 on ms Access server.
  3. satya Moderator

    WHy don't you use DTS rather than Linked Server?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page