|
|
|
date: Thu, 28 Aug 2008 07:54:01 -0700,
group: microsoft.public.sqlserver.server
back
Re: Migrating from SQL 6.5 to SQL 2005
Since I have to keep my v6.5 computer around, I need to either install 7.0 or
2000 on another computer. This is now where I'm in a bind. I have the MSDN
install CDs (Developer Edition) for it but I can't find the CD keys for
either of these. When I try and look up the keys under MSDN (online), it
doesn't go back that far. If I can copy databases from 6.5 to 2000 then that
is what I would like to do. I've
What's the best solution?
BrianR
"Tibor Karaszi" wrote:
> Basically the same upgrade wizard that is in 7.0 also came with 2000. There's a whole section in
> 2000 Books Online on how to upgrade from 6.5. Basically the Wizard connects to your 6.5 instance and
> based on that creates the database, the objects and finally copies over the data from the 6.5
> install to your 2000 install. So, no in-place upgrade of any type.
>
> You cannot restore or attach 6.5 backups/databases on 7.0, 2000, 2005 or 2008. Upgrade wizard is the
> way to go and the most recent version it was shipped with was 2000.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
>
> "BrianR" wrote in message
> news:A7B88F31-4505-4C04-B077-D19D5001CDB6@microsoft.com...
> > I've read that I can't copy databases directly from SQL 6.5 to SQL 2005. Can
> > I copy databases from SQL 6.5 to SQL 2000?
> >
> > If not, I will need to install SQL 7.0. Will it install on XP Pro?
> >
> > I have an install CD from MSDN but I can't find any product keys for a CD
> > this old. Any ideas?
> >
> > Thanks,
> >
> > BrianR
>
>
date: Thu, 28 Aug 2008 08:51:01 -0700
author: BrianR
Re: Migrating from SQL 6.5 to SQL 2005
As far as I recall, SQL Server never required CD keys, at least not the MSDN version. IT is either
not at all required or already filled in for you.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"BrianR" wrote in message
news:70066B35-1283-414C-8243-B4E3C61A0CE0@microsoft.com...
> Since I have to keep my v6.5 computer around, I need to either install 7.0 or
> 2000 on another computer. This is now where I'm in a bind. I have the MSDN
> install CDs (Developer Edition) for it but I can't find the CD keys for
> either of these. When I try and look up the keys under MSDN (online), it
> doesn't go back that far. If I can copy databases from 6.5 to 2000 then that
> is what I would like to do. I've
>
> What's the best solution?
>
> BrianR
>
> "Tibor Karaszi" wrote:
>
>> Basically the same upgrade wizard that is in 7.0 also came with 2000. There's a whole section in
>> 2000 Books Online on how to upgrade from 6.5. Basically the Wizard connects to your 6.5 instance
>> and
>> based on that creates the database, the objects and finally copies over the data from the 6.5
>> install to your 2000 install. So, no in-place upgrade of any type.
>>
>> You cannot restore or attach 6.5 backups/databases on 7.0, 2000, 2005 or 2008. Upgrade wizard is
>> the
>> way to go and the most recent version it was shipped with was 2000.
>>
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>>
>> "BrianR" wrote in message
>> news:A7B88F31-4505-4C04-B077-D19D5001CDB6@microsoft.com...
>> > I've read that I can't copy databases directly from SQL 6.5 to SQL 2005. Can
>> > I copy databases from SQL 6.5 to SQL 2000?
>> >
>> > If not, I will need to install SQL 7.0. Will it install on XP Pro?
>> >
>> > I have an install CD from MSDN but I can't find any product keys for a CD
>> > this old. Any ideas?
>> >
>> > Thanks,
>> >
>> > BrianR
>>
>>
date: Thu, 28 Aug 2008 17:54:16 +0200
author: Tibor Karaszi
Re: Migrating from SQL 6.5 to SQL 2005
I only had time to try installing 7.0 this morning and it did ask for a CD
key. I'll try 2000 later on today and hopefully you are right.
BrianR
"Tibor Karaszi" wrote:
> As far as I recall, SQL Server never required CD keys, at least not the MSDN version. IT is either
> not at all required or already filled in for you.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
>
> "BrianR" wrote in message
> news:70066B35-1283-414C-8243-B4E3C61A0CE0@microsoft.com...
> > Since I have to keep my v6.5 computer around, I need to either install 7.0 or
> > 2000 on another computer. This is now where I'm in a bind. I have the MSDN
> > install CDs (Developer Edition) for it but I can't find the CD keys for
> > either of these. When I try and look up the keys under MSDN (online), it
> > doesn't go back that far. If I can copy databases from 6.5 to 2000 then that
> > is what I would like to do. I've
> >
> > What's the best solution?
> >
> > BrianR
> >
> > "Tibor Karaszi" wrote:
> >
> >> Basically the same upgrade wizard that is in 7.0 also came with 2000. There's a whole section in
> >> 2000 Books Online on how to upgrade from 6.5. Basically the Wizard connects to your 6.5 instance
> >> and
> >> based on that creates the database, the objects and finally copies over the data from the 6.5
> >> install to your 2000 install. So, no in-place upgrade of any type.
> >>
> >> You cannot restore or attach 6.5 backups/databases on 7.0, 2000, 2005 or 2008. Upgrade wizard is
> >> the
> >> way to go and the most recent version it was shipped with was 2000.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://sqlblog.com/blogs/tibor_karaszi
> >>
> >>
> >> "BrianR" wrote in message
> >> news:A7B88F31-4505-4C04-B077-D19D5001CDB6@microsoft.com...
> >> > I've read that I can't copy databases directly from SQL 6.5 to SQL 2005. Can
> >> > I copy databases from SQL 6.5 to SQL 2000?
> >> >
> >> > If not, I will need to install SQL 7.0. Will it install on XP Pro?
> >> >
> >> > I have an install CD from MSDN but I can't find any product keys for a CD
> >> > this old. Any ideas?
> >> >
> >> > Thanks,
> >> >
> >> > BrianR
> >>
> >>
>
>
date: Thu, 28 Aug 2008 09:01:24 -0700
author: BrianR
|
|