porting code for sqlsvr to my-sql

[VISOR]

Hi.
Is there any fast and automated way to port an application written for
sqlserver with sqlConnection, sqlDA and so on to work with MySQL? I've seen
there are some providers for mysql. Anyone knows some way to convert the
program at cthe code level to support mysql?

thanks.

 

[William Ryan]

I don't know of any tools, but that's not to say there aren't any. In large
part, it will depend on your code...if you are using StoredProcs, then
you'll definitely have some porting to do. However, assuming you don't, if
you add the reference to the MySQL Provider, and then do a find and replace
throughout the project, that should accomplish most of the task for you.
Obviously the DataAdapters may need some changing depending of things like
Identity columns and all, but AutoIncrement is usually set client side so I
don't even foresee a problem there.

HTH,

Bill