Re: How to use DTS to transfer 6.5 databases to 2000
iranpessar_at_hotmail.com
Date: 10/19/04
- Next message: Darren Green: "Re: Download with DTS http - not ftp"
- Previous message: Andrew J. Kelly: "Re: Scheduled Job Fails, But Runs Successfully Interactively"
- In reply to: Allan Mitchell: "Re: How to use DTS to transfer 6.5 databases to 2000"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 19 Oct 2004 09:05:03 -0700
I have a new instance of SQL server 2000 installed. I do not have a
connection to the 6.5 databse. I need to be able to convert the 6.5 database
from a .dmp or .dat to a readable file that 2000 will understand and restore.
"Allan Mitchell" wrote:
> 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/prodtechnol/sql/2000/deploy/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@discussions.microsoft.com> wrote in message
> news:BA3D9C90-D0EE-4D06-B25E-9F52EB49C674@microsoft.com...
> >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?
>
>
>
- Next message: Darren Green: "Re: Download with DTS http - not ftp"
- Previous message: Andrew J. Kelly: "Re: Scheduled Job Fails, But Runs Successfully Interactively"
- In reply to: Allan Mitchell: "Re: How to use DTS to transfer 6.5 databases to 2000"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
