msde admin tool ?

hi,
you proabably get this question a lot but can someone point me in the
direction of a free adminisatration tool for MSDE ?
why dont MS offer one (at least i cant find one)
(note: i have the enterprise manager but need an MSDE admin tool for sites
that dont have sql server).
Thanks
Scott
Scott,
Look at http://www.asql.biz/DbaMgr.shtm
It's a free and useful utility from Andrea Montanari.
Lars Broberg
Elbe-Data AB
http://www.elbe-data.se
Remove "nothing." when replying to private e-mail!
scott wrote:
> hi,
> you proabably get this question a lot but can someone point me in the
> direction of a free adminisatration tool for MSDE ?
> why dont MS offer one (at least i cant find one)
> (note: i have the enterprise manager but need an MSDE admin tool for sites
> that dont have sql server).
> Thanks
> Scott
>
|||thanks for reply
Scott
|||check out this Lite-Version ...
http://sqlmanager.net/products/mssql/manager/
bye,
Helmut
|||Hi Scott,
There's one at our site that's free for personal use too.
Enjoy.
Regards,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"scott" <nospamscott@.yahoo.com> wrote in message
news:e51SsUSOFHA.2680@.TK2MSFTNGP09.phx.gbl...
> hi,
> you proabably get this question a lot but can someone point me in the
> direction of a free adminisatration tool for MSDE ?
> why dont MS offer one (at least i cant find one)
> (note: i have the enterprise manager but need an MSDE admin tool for sites
> that dont have sql server).
> Thanks
> Scott
>

msde 2000 and sql server

Hi group!
I am developing an application using MSDE 2000.
I made a Setup.exe by using Installshield tool.
in Installshield I add the msde2000.msm with named
instance. so msde2000 will be installed to the end client
machine.
my question is if the end client machine has SQL server
(for example version 2000, 7.5, 6.0), after my installtion
the sql server in end client machine is still OK?
I found the msde installtion will install dll file to
C:\Program Files\Microsoft SQL Server\80,if end client
machine has SQL server, the msde installtion will rewrite
C:\Program Files\Microsoft SQL Server\80.
thank?
yan
Hi Yan,
I'd strongly suggest you:
1. Modify the setup.ini file to have the settings you want for MSDE and to
install it with an instance name that is unique to you. (That will avoid any
clash with an existing installation)
2. Get the end-customer to run the ms-supplied setup for the MSDE before
installing your app.
Unfortunately, there are just way too many problems with auto-installing it
at present. These will be rectified with SQL Express in the future.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"ycjj" <yan@.mcr-sol.pic.melco.co.jp> wrote in message
news:061a01c49b8f$74866590$a301280a@.phx.gbl...
> Hi group!
> I am developing an application using MSDE 2000.
> I made a Setup.exe by using Installshield tool.
> in Installshield I add the msde2000.msm with named
> instance. so msde2000 will be installed to the end client
> machine.
> my question is if the end client machine has SQL server
> (for example version 2000, 7.5, 6.0), after my installtion
> the sql server in end client machine is still OK?
> I found the msde installtion will install dll file to
> C:\Program Files\Microsoft SQL Server\80,if end client
> machine has SQL server, the msde installtion will rewrite
> C:\Program Files\Microsoft SQL Server\80.
> thank?
> yan

MSDE 2000 Administration tool

Hi all,

I have installed MSDE on my computer but it's missing, as all you already
know, a serious (well, osql IS TOO serious but not very newbie friendly)
admin tool.

I have downloaded http://www.asql.biz/DbaMgr.shtm and i'm quite happy with
it but was wondering if there's something better or that may complete what
DbaMgr2k is missing... and preferably is as free as DbaMgr2k.

Thank You,
LorenzoHi

There is a list at:
http://www.aspfaq.com/show.asp?id=2442

John

"Lorenzo Bolognini" <lorenzo@.mysurname.net> wrote in message
news:pkd_a.43324$an6.1479482@.news1.tin.it...
> Hi all,
> I have installed MSDE on my computer but it's missing, as all you already
> know, a serious (well, osql IS TOO serious but not very newbie friendly)
> admin tool.
> I have downloaded http://www.asql.biz/DbaMgr.shtm and i'm quite happy with
> it but was wondering if there's something better or that may complete what
> DbaMgr2k is missing... and preferably is as free as DbaMgr2k.
> Thank You,
> Lorenzo|||Thank you very much John.

Lorenzo

MSDE & SQL Server 2000 on the same machine !

Hi all,

I started learning ASP .Net using the "Teach yourself ASP.Net in 24 hours". In that book, the applications use MSDE as the database tool.

Now i have started developing some big applications and have installled MS SQL Server 2000 on my machine.

I still have databases on the MSDE.

My question is 'How do i move the old databases from MSDE to SQL Server 2000' ?

Can i uninstall MSDE safely since i already installed SQL Server 2000 ?

Please let me know.

Thank You
:-)you can detach them all, then re-attach them to SQL Server 2k - then ditch the MSDE instance. though you don't actually need to...|||What is the exact step by step process to install SQL Server 2000 if you have a previously installed version of MSDE?

I want to start over, get rid of MSDE and install SQL Server 2000. I'm using Visual Studio 2003 and I have seen several discussion threads that indicate that re-installing MSDE can be EXTREMELY complicated. I'm not a hacker... just a newbie who wants to develop ASP.NET sites. Are there any gotchas I need to be aware of?

What EXACTLY is the process? Do I quite the server manager, uninstall MSDE and then install SQL Server 2000? Are there any clear install guides out there that people can suggest?

TIA

:-)