[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2259
  • Last Modified:

MS SQL Express vs MySql

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]



0
jonalan
Asked:
jonalan
  • 4
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
jonalan,
> 4] Comparison between the 2 ? [50 points]

http://swik.net/MySQL/MySQL+vs+MS+SQL+Server
0
 
luaniCommented:
>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.
0
 
luaniCommented:
>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
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
jonalanAuthor 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
0
 
luaniCommented:
>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
0
 
luaniCommented:
see also www.blueportal.org for books
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now