Wednesday, March 21, 2012

MSDE or SQLServer Express

Hi
In our vb.net application we are using sqlserver2000 database. we are
planning to move to another free database engines.I have few queries.
1.in MSDE or SQLServer Express which one i have to select
2.Where can i get the documentation of how to dump my database in those
because those don't have a User interface.
3.can i redistribute those databases
4.can i access those stored in another system in a network.
5.what if 2 or 3 application directly accessing that at the same time.
hope i delivered my question properly.any help is appreciable
-regards
GRK
Hi Andrea ,
Thank you very much for your suggestion.I'll check the links you have
sent and come back to you with other queries.Thanks a lot
-GRK
"Andrea Montanari" wrote:

> hi,
> GRK wrote:
> SQLExpress is newer than MSDE, and MSDE will not be supported on Vista
> platform..
> I'd go for SQLExpress as it will be better supported anyway..
> for SQLExpress you can freely download the "official" management tool, SQL
> Server Management Studio Express at
> http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
> for MSDE there's no official graphical tool available, but you can have a
> look at a free prj of mine, DbaMgr2k, available at
> http://www.asql.biz/en/DbaMgr.aspx
> both engines are free to use.. you have to freely register for distribution
> if you plan to;
> SQLExpress: http://go.microsoft.com/fwlink/?LinkId=64062
> MSDE :
> http://www.microsoft.com/sql/prodinfo/previousversions/msde/redistregister.mspx
> yes... you have to enable remote connections as, by default, both products
> disable network protocols at installation time.. you can modify this
> behaviour both at install time and later, at "runtime"..
> SQL Server is full client/server database engine.. it will handle that
> appropriately :D
> but you have to deal with concurrency scenarios in your apps..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> -- remove DMO to reply
>
>
|||Small Doubt Mr Andrea,
I'm using visual studio.net 2003 is it compatible when i install
ServerExpress
-GRK
"Andrea Montanari" wrote:

> hi,
> GRK wrote:
> SQLExpress is newer than MSDE, and MSDE will not be supported on Vista
> platform..
> I'd go for SQLExpress as it will be better supported anyway..
> for SQLExpress you can freely download the "official" management tool, SQL
> Server Management Studio Express at
> http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
> for MSDE there's no official graphical tool available, but you can have a
> look at a free prj of mine, DbaMgr2k, available at
> http://www.asql.biz/en/DbaMgr.aspx
> both engines are free to use.. you have to freely register for distribution
> if you plan to;
> SQLExpress: http://go.microsoft.com/fwlink/?LinkId=64062
> MSDE :
> http://www.microsoft.com/sql/prodinfo/previousversions/msde/redistregister.mspx
> yes... you have to enable remote connections as, by default, both products
> disable network protocols at installation time.. you can modify this
> behaviour both at install time and later, at "runtime"..
> SQL Server is full client/server database engine.. it will handle that
> appropriately :D
> but you have to deal with concurrency scenarios in your apps..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> -- remove DMO to reply
>
>

No comments:

Post a Comment