Schedule Update Query

[digger27]

For various business reasons not worth boring everyone with, I have two
databases in different locations. db2 uses a subset of data from db1. I
will be using db2 as a source of info for a website, among other uses. For
this reason, I don't want to use linked tables in db2 to display the data it
pulls from db1. I have a query written that will pull the needed data from
db1 into db2 and update my table. However, I don't want to have to go in
each day (or soon, every few hours) and run the query. Is it possible to
have this automated so that it runs on a schedule without being open? Have
tried to use the windows scheduler to open the db at a given time and had my
query set to run when the db opens, but the scheduler is not adequate for
this.
Any advise would be greatly appreciated.

 

[John Vinson]

For various business reasons not worth boring everyone with, I have two
databases in different locations. db2 uses a subset of data from db1. I
will be using db2 as a source of info for a website, among other uses.

Consider using "Replication" to synchronize these databases. It's a
complex subject but it's the best bet especially if the two databases
are connected over a WAN or the internet, rather than over a fast LAN.

There's a Replication Whitepaper at Microsoft's support website, and
lots more information at http://www.trigeminal.com.

John W. Vinson[MVP]