Migrating ASP.net application from using MsSQL to MySQL

Hi everybody,

I am currrently faced with the challenge of adding access to an extra
database in my asp.net application.
Up until now I have used only a mssql database (added through the
standard configurationfeatures for asp.net apps in Visual Studio .net
2003), but now I want to replace the old MsSQL database with a MySQL
database while keeping it open that I also add a second database later
on (this would probalbly be a MsSQL database.
The questions is: where do I modify the application in order to change
the database type from MSSQL to MySQL and is there something that I
will need to keep in mind so that I can both use a MySQL database and a
MSSQL database in the same asp.net app.

thanks in advance.

.

Relevant Pages

  • Re: Effect of MySQL being acquired by Sun Micro
    ... Sun sell hardware and solutions, ... I would EXPECT that the database engine itself, *might* get a bit of performance tuning against SUN's hardware, which may or may not emerge into the public domain. ... Because the top end is well covered by Oracle, so again I would EXPECT that MySQL will become a basic 'ships with the OS' type product, on which a lot of OS admin functions might be based, as well as it being a useful thing to have on board for less power hungry db apps. ...
    (comp.lang.php)
  • 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: Migrating ASP.net application from using MsSQL to MySQL
    ... MySQL DBs from .net. ... SQL (stored procedures? ... database in my asp.net application. ... Up until now I have used only a mssql database (added through the ...
    (microsoft.public.vstudio.general)
  • DBConvert for Access & MSSQL 2.0.0
    ... DBConvert for Access & MSSQL is a database migration tool for data ... If a direct access to your MSSQL server is denied (insufficient ... privileges) you can save your data into a MSSQL Dump file to overcome ...
    (comp.software.shareware.announce)
  • Re: Databases
    ... > The Freebsd server will keep a database of every customer address, ... > which opensource database would do this in the easiest possible way. ... MySQL is the way to good. ... web base apps. ...
    (freebsd-questions)