Hi,

I am fairly new to SQL so please forgive me for any
ignorance displayed!

I have 2 different SQL servers running on a network, both
have identical databases and table structure etc... I
want on a nightly basis to export all data from one of
the servers to the other server, I want this to be fully
automated, is this possible and if so how?

I can do the manual import/export using the Enterprise
Mangaer but obviously I do not want to have to do this
manually every night.

Any ideas?

TIA.

The two best ways to do this is either creating a DTS package that copies
the entire database and then running that package automatically using the
SQL Agent. Or you could accomplish this using replication.

Michael Otey

"TJ" <anonymous (AT) discussions (DOT) microsoft.com> wrote