We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

MS SQL Express vs MySql

jonalan
jonalan asked
on
Medium Priority
2,308 Views
Last Modified: 2008-01-09
Hi, guys..
I am new to DB..
Wanna ask some simple question (simple to you guys but not to me, hehe)
Recently I have downloaded MySQL and MS SQL Express and install in my pc.
I have few short questions here, just for your opinion as I need some undestandings.

Each Question will worth 20points (okay okay.. i know it's not much)

1]  I already installed the MS SQL Express but I do not know how to use it as tool require $$ to buy. Question: Is there any free tools for MS SQL Express? As in MYSQL, i am using "EMS SQL Manager 2005 Lite for MySQL" which work fine for me. [20 points]

2] If I were going for Wed development, which Database is more appropriate to use ? My SQL or MS SQL Express ? Why ? [20 points]

3] Is there any E-book or MS SQL Express to download (free), I have downloaded alot on MYSQL but souldn't find any for MY SQL Express. But there is MY SQL 7, issit the same ? [20 points]

4] Comparison between the 2 ? [50 points]

5] If I am using VB.NET and Java which DB better should I use? Why ? [40 points]



Comment
Watch Question

AneeshDatabase Consultant
CERTIFIED EXPERT
Top Expert 2009

Commented:
jonalan,
> 4] Comparison between the 2 ? [50 points]

http://swik.net/MySQL/MySQL+vs+MS+SQL+Server
Luan JubicaProject Manager

Commented:
>5] If I am using VB.NET and Java which DB better should I use? Why ? [40 points]
You are using them on the same time?
VB.NET fit better with MS SQL Express .
Java I think fit better with MySQL.
Luan JubicaProject Manager

Commented:
>3] Is there any E-book or MS SQL Express to download (free), I have downloaded alot on MYSQL but souldn't find any for >MY SQL Express. But there is MY SQL 7, issit the same ? [20 points]

I you find books on SQL 2005 i think it is the same per Express because it is just a lite version. you can check
www.flazx.com
www.ebookportal.org

Author

Commented:
>"5] If I am using VB.NET and Java which DB better should I use? Why ? [40 points]
You are using them on the same time?
VB.NET fit better with MS SQL Express .
Java I think fit better with MySQL."

Can I know why ?

>3] Is there any E-book or MS SQL Express to download (free), I have downloaded alot on MYSQL but souldn't find any for >MY SQL Express. But there is MY SQL 7, issit the same ? [20 points]

I you find books on SQL 2005 i think it is the same per Express because it is just a lite version. you can check
www.flazx.com --> paysite any free site ?
www.ebookportal.org --> not accessable
Project Manager
Commented:
>www.ebookportal.org --> not accessable
Typo error should  be : http://www.ebooksportal.org/


>Can I know why ?
VB.NET fit better with MS SQL Express . Both are microsoft technology build with the idea to fit together. .NET has native client for SQL Server.
When I say Java I mean Sun Java. There are very few programs build on SQL Server with Java front end because SQL Server it is not their target, it fit well with Oracle, MySQL

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Luan JubicaProject Manager

Commented:
see also www.blueportal.org for books
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.