Hello
I am migrating a SQL server from one (old) SQL server to another (new) SQL
server. How do I move my DTS Local Packages, jobs, and Replication info
from the old server to the new server? Will this be something that I can do
with a restore from a taped backup of the (old)SQL server to the new server?

Thanks for any help.

DTS packages a lot of people use this

Transferring DTS Packages
(http://www.sqldts.com/default.aspx?204)

The other two can be done by scripting and editing the scripts for server
names etc.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"JimS" <noholycowser21spam (AT) ya_NoJunk_hoo (DOT) com> wrote

Excellent!!!
Thanks for the help Allan...I really appreciate it!
Good luck
TTFN
Jim



"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

DTS packages a lot of people use this

Transferring DTS Packages
(http://www.sqldts.com/default.aspx?204)

The other two can be done by scripting and editing the scripts for server
names etc.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"JimS" <noholycowser21spam (AT) ya_NoJunk_hoo (DOT) com> wrote