Going to SQL7 DE to SQL 2000 MSDE

Hi All
Does anyone know if there is a path to change a database
from MSSQL 7 Desktop Edition (note, not desktop engine) to
MSDE 2000 ?
Thanks
JI very much doubt that there's some setup program that will upgrade the 7.0
DE to 2000 MSDE. My guess is that you have to use backup/restore or
detach/attach - something that you can't do for the system databases (they
can't cross editions).
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"J" <anonymous@.discussions.microsoft.com> wrote in message
news:05c401c3bed1$a6597a30$a401280a@.phx.gbl...
> Hi All
> Does anyone know if there is a path to change a database
> from MSSQL 7 Desktop Edition (note, not desktop engine) to
> MSDE 2000 ?
> Thanks
> J|||Hi
Do you recommend that I first update the database to SQL
2000 and then do a backup and restore into MSDE?
Do you know where I can find documentation on restoring
into MSDE?
Thanks
J
>--Original Message--
>I very much doubt that there's some setup program that
will upgrade the 7.0
>DE to 2000 MSDE. My guess is that you have to use
backup/restore or
>detach/attach - something that you can't do for the
system databases (they
>can't cross editions).
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"J" <anonymous@.discussions.microsoft.com> wrote in message
>news:05c401c3bed1$a6597a30$a401280a@.phx.gbl...
>> Hi All
>> Does anyone know if there is a path to change a database
>> from MSSQL 7 Desktop Edition (note, not desktop engine)
to
>> MSDE 2000 ?
>> Thanks
>> J
>
>.
>|||I'm not sure. I haven't dealt with MSDE so I don't know about all the setup
quirks that MSDE has. But upping to Personal Edition 2000 first sounds like
a good idea (make it the same service pack as well), because you now have
the option to restore both system and user databases as well. The restore
process is the same for a regular SQL Server, the RESTORE command. I suggest
you post to the msde group, as you might find more specific suggestions
there.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"J" <anonymous@.discussions.microsoft.com> wrote in message
news:1147a01c3bf5f$63eb4ff0$a601280a@.phx.gbl...
> Hi
> Do you recommend that I first update the database to SQL
> 2000 and then do a backup and restore into MSDE?
> Do you know where I can find documentation on restoring
> into MSDE?
> Thanks
> J
>
> >--Original Message--
> >I very much doubt that there's some setup program that
> will upgrade the 7.0
> >DE to 2000 MSDE. My guess is that you have to use
> backup/restore or
> >detach/attach - something that you can't do for the
> system databases (they
> >can't cross editions).
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at:
> >http://groups.google.com/groups?
> oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> >"J" <anonymous@.discussions.microsoft.com> wrote in message
> >news:05c401c3bed1$a6597a30$a401280a@.phx.gbl...
> >> Hi All
> >> Does anyone know if there is a path to change a database
> >> from MSSQL 7 Desktop Edition (note, not desktop engine)
> to
> >> MSDE 2000 ?
> >> Thanks
> >> J
> >
> >
> >.
> >