Re: Migrating ASP.net application from using MsSQL to MySQL
- From: "tbh" <femdev@xxxxxxxxxxxxxxxxx>
- Date: Sun, 10 Sep 2006 12:51:39 +0200
hi, while i haven't done quite this i have successfully used both MSSQL and
MySQL DBs from .net. i assume you've found something like this:
http://dev.mysql.com/tech-resources/articles/dotnet/index.html#ADO.NET
as you can see, there are MySql analogs of the SqlData interfaces you have
probably been using. now i'm not quite sure what your constraints are. is it
enough to build a version of your application that uses MySql instead of
SQLServer? (i'm assuming here that you have a MySql DB that performs all the
SQL (stored procedures? full text? plenty of potential snags come to mind)
you do now with SQL Server).
if so, that is almost as easy as
1) search-replace
SqlConnection to MySqlConnection (and analogous for the other objects)
2) change your machine.config to connect to the MySql DB instead of the SQL
Server one
if, however, you need to be able to support either database (e.g. by just
changing some configuration settings) you'll have more work to do.
Tim Hanson
<thomasnorlund@xxxxxx> wrote in message
news:1157636996.103446.126600@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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.
.
- Follow-Ups:
- Re: Migrating ASP.net application from using MsSQL to MySQL
- From: thomasnorlund
- Re: Migrating ASP.net application from using MsSQL to MySQL
- References:
- Migrating ASP.net application from using MsSQL to MySQL
- From: thomasnorlund
- Migrating ASP.net application from using MsSQL to MySQL
- Prev by Date: Nav keys not working in IDE
- Next by Date: VSTS 2005 - Adding new users to the team project
- Previous by thread: Migrating ASP.net application from using MsSQL to MySQL
- Next by thread: Re: Migrating ASP.net application from using MsSQL to MySQL
- Index(es):
Relevant Pages
|
