Re: Microsoft SQL Desktop Engine - using

"Nicholas Paldino [.NET/C# MVP]" <mvp@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:O9$1qnFPFHA.3076@xxxxxxxxxxxxxxxxxxxxxxx

> Or, you could use alternatives to SQL server, like mySql. However, I
> can't really speak for the capabilities, or ease of use in .NET.

I can! mySQL is a wonderful product, so long as you require only "standard"
RDBMS functionality i.e. the storage and retrieval of relational data. In
that case, it has several huge advantages over SQL Server, Oracle, Sybase
etc...

1) It's free! And, at the risk of repeating myself, IT'S FREE!!!

2) Due to its (relatively!) restricted functionality, it's extremely fast -
even *performant*, as our American friends are wont to say... :-) Currently
at version 4.1, version 5.0 will have support for stored procedures and
triggers.

3) There is an excellent native .NET data provider available from CoreLabs,
which already supports version 2 of the .NET Framework.

For more information, check out these links:

http://www.mysql.com/products/mysql/
For the database engine itself, including feature comparisons with lots of
other RDBMS.

http://www.navicat.com/
For a management front-end, akin to SQL Server Enterprise Manager

http://crlab.com/mysqlnet/
For the native .NET data provider.


.

Relevant Pages

  • Re: SQL server vs mySQL ???
    ... SQL Server has the broadest range of tools and support utilities of any database system on the planet--by far. ... MS SQL versus MySQL? ... As of 5.0, MySQL finally supports stored procedures, so they are very similar there (you can genericize your data access a bit due to sprocs in both). ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Transfer LARGE DB from MySQL to SQL Server 2K5 problems
    ... newsgroups are managed (and making that a selling point for MSDN ... forums, which, needless to say, drives me away from the MS web sites, and is ... I am going through the MySQL ODBC v3.51 driver, ... streaming across the wire to my SQL Server box. ...
    (microsoft.public.sqlserver.dts)
  • Re: Newbie, True and False
    ... All commands, Insert, Update etc work fine with MySql, but not with MsSql. ... First time working on an SQL database. ... will need to relearn when using sql server. ...
    (microsoft.public.sqlserver.clients)
  • Re: Access 2007 and MySQL
    ... Anyone tried MySQL as backend for recent Acc2k7 FE developments? ... You can however if you want choose SQL server for your back end and then you ... For the most part most your recordset code and most queries should work as ... Set rstRecords = CurrentDb.OpenRecordset ...
    (comp.databases.ms-access)
  • Synchronising a DataRow in one DataSet with a structurally identical DataRow from another DataSet
    ... Supposing you had several remote MySQL databases, one for each client, each ... SQL Server table on a nightly basis, ... DataSet from the destination SQL Server table which matches the primary key. ... existing record in the SQL Server table, so we instantiate a DataRow object ...
    (microsoft.public.dotnet.framework.adonet)