I want to move my sql server 2000 to new hardware with the same name. In
particular, i have to move the DTS packages (and there are a lot of them).
I have tried looking this up on microsoft, but haven't found the proper
article yet.

Is it possible to give the new server a new name, use the copy database
wizard, take down the old server, reset the server account in AD, and then
rename the new server? Will that move all the DTS packages?

thanks

bj daniels
DanielsB (AT) gunnery (DOT) org

DTS packages are in general stored in MSDB. The only things of concern are
the connection names. If they match the new server name then you should be
OK.

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"bj daniels" <danielsb (AT) gunnery (DOT) org> wrote

Hi, you can use DTSBackup 2000 to save all your DTS Package in the old
Server and later load in the new Server, you can find it here:
http://www.sqldts.com/default.aspx?242

Thank.




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

thanks!


"Wenceslao Leon" <wleon (AT) netmail (DOT) cl> wrote