Database compatibility between MSDE and SQL Server 2000

I have a database that was created in SQL Server 2000. Would there be any
issues if I used this database in MSDE? Does anyone know of any document
regarding this? All the articles I have read talk about MSDE databases being
compatible with SQL Server 2000. None of them discussed the reverse case.
Thanks in advance!
hi Anushree,
"Anushree Laturkar" <anushree.laturkar@.bindview.com> ha scritto nel
messaggio news:%23WE5kkx7EHA.3504@.TK2MSFTNGP12.phx.gbl
> I have a database that was created in SQL Server 2000. Would there be
> any issues if I used this database in MSDE? Does anyone know of any
> document regarding this? All the articles I have read talk about MSDE
> databases being compatible with SQL Server 2000. None of them
> discussed the reverse case.
> Thanks in advance!
MSDE 2000 and SQL Server 2000 databases are compatible as the engine is the
same.. MSDE only has "added" features in the Storage Engine regarding checks
for datab files not exceeding 2gb upper limit
but the core architechture is the same, so you can move users SQL Server
2000 databases to MSDE 2000 and vice versa..
the same applied service pack level is appreciated
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Database compatibility between MSDE and SQL Server 2000

I have a database that was created in SQL Server 2000. Would there be any
issues if I used this database in MSDE? Does anyone know of any document
regarding this? All the articles I have read talk about MSDE databases being
compatible with SQL Server 2000. None of them discussed the reverse case.
Thanks in advance!
MSDE and SQL Server is the same. There are some features not available on MSDE, but I doubt you will
run into them...
http://msdn.microsoft.com/library/en...ar_ts_1cdv.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Anushree Laturkar" <anushree.laturkar@.bindview.com> wrote in message
news:ubDnKkx7EHA.2608@.TK2MSFTNGP10.phx.gbl...
>I have a database that was created in SQL Server 2000. Would there be any
> issues if I used this database in MSDE? Does anyone know of any document
> regarding this? All the articles I have read talk about MSDE databases being
> compatible with SQL Server 2000. None of them discussed the reverse case.
> Thanks in advance!
>
|||As long as you are talking about MSDE 2.0, not the MSDE 1.0 that came out
with SS 7.0.
Out of curiosity, why would you want to revert back like this? If you are
looking at a development platform, why not deploy SS Developer Edition.
Microsoft has recently dropped the price on this edition down to $50 and you
get the full Enterprise Edition for development purposes without any sort of
throttles or restrictions.
Sincerely,
Anthony Thomas

"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23tq6A8y7EHA.3236@.TK2MSFTNGP15.phx.gbl...
MSDE and SQL Server is the same. There are some features not available on
MSDE, but I doubt you will
run into them...
http://msdn.microsoft.com/library/en...ar_ts_1cdv.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Anushree Laturkar" <anushree.laturkar@.bindview.com> wrote in message
news:ubDnKkx7EHA.2608@.TK2MSFTNGP10.phx.gbl...
>I have a database that was created in SQL Server 2000. Would there be any
> issues if I used this database in MSDE? Does anyone know of any document
> regarding this? All the articles I have read talk about MSDE databases
being
> compatible with SQL Server 2000. None of them discussed the reverse case.
> Thanks in advance!
>

Database compatibility between MSDE and SQL Server 2000

I have a database that was created in SQL Server 2000. Would there be any
issues if I used this database in MSDE? Does anyone know of any document
regarding this? All the articles I have read talk about MSDE databases being
compatible with SQL Server 2000. None of them discussed the reverse case.
Thanks in advance!MSDE and SQL Server is the same. There are some features not available on MS
DE, but I doubt you will
run into them...
http://msdn.microsoft.com/library/e..._ar_ts_1cdv.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Anushree Laturkar" <anushree.laturkar@.bindview.com> wrote in message
news:ubDnKkx7EHA.2608@.TK2MSFTNGP10.phx.gbl...
>I have a database that was created in SQL Server 2000. Would there be any
> issues if I used this database in MSDE? Does anyone know of any document
> regarding this? All the articles I have read talk about MSDE databases bei
ng
> compatible with SQL Server 2000. None of them discussed the reverse case.
> Thanks in advance!
>|||As long as you are talking about MSDE 2.0, not the MSDE 1.0 that came out
with SS 7.0.
Out of curiosity, why would you want to revert back like this? If you are
looking at a development platform, why not deploy SS Developer Edition.
Microsoft has recently dropped the price on this edition down to $50 and you
get the full Enterprise Edition for development purposes without any sort of
throttles or restrictions.
Sincerely,
Anthony Thomas
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23tq6A8y7EHA.3236@.TK2MSFTNGP15.phx.gbl...
MSDE and SQL Server is the same. There are some features not available on
MSDE, but I doubt you will
run into them...
http://msdn.microsoft.com/library/e..._ar_ts_1cdv.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Anushree Laturkar" <anushree.laturkar@.bindview.com> wrote in message
news:ubDnKkx7EHA.2608@.TK2MSFTNGP10.phx.gbl...
>I have a database that was created in SQL Server 2000. Would there be any
> issues if I used this database in MSDE? Does anyone know of any document
> regarding this? All the articles I have read talk about MSDE databases
being
> compatible with SQL Server 2000. None of them discussed the reverse case.
> Thanks in advance!
>