MSDE -> SQL2005Express

Hello, Can I upgrade MSDE to SQL2005 Express without lost any DB.
Thank you very much for help.
Best regards
hi,
Petr Jirman wrote:
> Hello, Can I upgrade MSDE to SQL2005 Express without lost any DB.
> Thank you very much for help.
> Best regards
yes, you can .. http://msdn2.microsoft.com/en-us/library/ms143393.aspx
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||Hello,
There will not be any data loss.
1. Install SQL Express
2. Backup the databases in MSDE
3. Restore the backup in SQL Express.
Thanks
Hari
"Petr Jirman" <PetrJirman@.discussions.microsoft.com> wrote in message
news:183A89E5-48F3-4A58-9D91-327DC3FFEA15@.microsoft.com...
> Hello, Can I upgrade MSDE to SQL2005 Express without lost any DB.
> Thank you very much for help.
> Best regards
|||Hi, thank you
PLS Do you know how can I make upgrade ? I would like upgrade with CMD
command. I have 263 instance of MSDE and I cannot say the SA password to any
other peaple (they is only PC worker).
"Andrea Montanari" wrote:

> hi,
> Petr Jirman wrote:
> yes, you can .. http://msdn2.microsoft.com/en-us/library/ms143393.aspx
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> -- remove DMO to reply
>
>
|||hi,
Petr Jirman wrote:
> Hi, thank you
> PLS Do you know how can I make upgrade ? I would like upgrade with CMD
> command. I have 263 instance of MSDE and I cannot say the SA password
> to any other peaple (they is only PC worker).
aghhh!!!
you could prepare a "setting" file that will "include" the "secret" sa pwd
to be consumed so that you only have to burn a cd with SQLExpress installer
and the setting ini file and perform, for each computer, the required
installation.. the installer must be called, in that scenario, including the
setting file parameter..
or you can include in the cd a batch file calling the installer with all
required parameters..
you can have a look at all supported parameters at
http://msdn2.microsoft.com/en-us/library/ms144259.aspx, including setting's
ini file ...
when finished you have to trash the cd :D
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||Consider that when you convert your MSDE (SQL Server 2000) by attaching the
..MDF file to a SQL Server 2005 Express master database, the file itself will
be morphed and made unreadable by MSDE. When the conversion is done, the
database compatibility level will be set to 8.0 (SQL Server 2000) so most of
the SQL Server 2005 features won't work against the newly converted
database. To correct this, you'll need to use SQL Server Enterprise Manager
Express to change the Compatibility Level to 9.0. When you do the engine
scrubs the database looking for issues that you might need to correct before
it can be fully 9.0 (SQL Server 2005) compatible.
I discuss these issues in more detail in my book.
hth
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest books:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and
Hitchhiker's Guide to SQL Server 2005 Compact Edition
------
"Petr Jirman" <PetrJirman@.discussions.microsoft.com> wrote in message
news:183A89E5-48F3-4A58-9D91-327DC3FFEA15@.microsoft.com...
> Hello, Can I upgrade MSDE to SQL2005 Express without lost any DB.
> Thank you very much for help.
> Best regards