I have 6 database instances across 4 servers running NT Server and SQL 6.5.
All instances have the same table design, columns, etc. I would like to dump
these databases (should I use a .dmp file?) and import them into 1 instance/
1 database using SQL 2000 Enterprise. Where would I start? How would I
start using DTS to accomplish this?

If you want to simply move the structure + data then you can use an ODBC
connection to the 6.5 servers and move it using DTS but if you want to
upgrade the whole thing then look here

http://www.microsoft.com/technet/pro...y/sqlugrd.mspx

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Programmers shouldn't be DBA's" <Programmers shouldn't be
DBA's (AT) discussions (DOT) microsoft.com> wrote