Re: SQL Import/Export
From: Michael Otey (mikeo_at_teca.com)
Date: 07/13/04
- Next message: Allan Mitchell: "Re: export to .ics format"
- Previous message: Joe: "A data updating Package fails following a database creating Package (MSSQL server)"
- In reply to: TJ: "SQL Import/Export"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 12 Jul 2004 21:27:15 -0700
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@discussions.microsoft.com> wrote in message
news:2ae3001c46857$e3b35240$a601280a@phx.gbl...
> 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.
- Next message: Allan Mitchell: "Re: export to .ics format"
- Previous message: Joe: "A data updating Package fails following a database creating Package (MSSQL server)"
- In reply to: TJ: "SQL Import/Export"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
