[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: [cobalt-users] ASP and MySQL

> -----Original Message-----
> From: Tolentino, Elmer [mailto:etolentino@xxxxxxxxx] 
> Sent: Friday, July 11, 2003 2:25 PM
> To: cobalt-users@xxxxxxxxxxxxxxx
> Subject: [cobalt-users] ASP and MySQL
> 
> 
> Hi All,
> 
> Hi has anyone implemented ASP pages and ODBC connection to 
> MySQL?  If someone wanted to migrate MS SQL to MySQL and the 
> pages are in ASP, will this be possible.

Haven't gone from MS SQL to MySQL, but I have moved applications between other databases (DBASE5 to MS SQL and AS400 to MS SQL). As long as you have the drivers for the new database, this won't be a problem. What you do have to look out for is code that is specific to one database. Some SQL Servers implements their version of the SQL language a little different. If all you are doing is some simple INSERT, UPDATE, SELECT, DELETE statements, you should be just fine.
Issues you may run into - IF you use these features:
	The drivers may handle cursors differently. (i.e. one driver may not support them)
	If you use seeds in MS SQL (Autoincrement the primary key on new inserts), make sure the table is set up the same way in MySQL.
	If you use indexes and have relationships defined, make sure you migrate them in the same way - or you may run into some bugs that are hard to track down.

Hope this helps.
Vidar
> 
> Thanks in advance.
> 
> ~Elmer
> 
> _____________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To subscribe/unsubscribe, or to SEARCH THE ARCHIVES, go to: 
> http://list.cobalt.com/mailman/listinfo/cobalt> -users
>