[Mono-aspnet-list] MS SQL to MySQL

[Joe Audette]

I once migrated from MS SQL to MySql using SqlYog. I think it required
the Enterprise version but it was not expensive. I created a
comparable schema in MySql and then used odbc queries to get the data
from MS SQL from within sqlyog and then ran queries to insert the data
into the tables in MySql.
It wasn't a trivial task but it wasn't too bad either. I was actually
going into a different schema because I was migrating from Rainbow
Portal/MS SQL into mojoPortal MySql so it should be even easier if the
schemas line up. I had to map some columns using the queries.

google Sqlyog, they have a free version too but not sure it supports
the odbc queries needed to get the data from ms sql like the paid
version has.

Hopefully by ASP, you mean ASP.NET, mono can't run ASP aka Classic
ASP, though I think there is something out there that can run ASP on
linux, chilisoft comes to mind.

Hope it helps,

Joe

On Thu, May 7, 2009 at 5:42 AM, Rob UKC <rob at ukcdesign.com> wrote:
>
> HI.
>
> I'm thinking of using Mono to run an ASP site on my Linux server, however
> the site also runs a MS SQL database.  Can anyone advise how i would go
> about setting a MS SQL database up on a Linux server using Mono?  Or can
> anyone advise how i could maybe convert it to MySQL?
>
> Any advice welcomed on this one!
>
> Cheers
>
> Rob
> --
> View this message in context: http://www.nabble.com/MS-SQL-to-MySQL-tp23423343p23423343.html
> Sent from the Mono - ASP.NET mailing list archive at Nabble.com.
>
> _______________________________________________
> Mono-aspnet-list mailing list
> Mono-aspnet-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-aspnet-list
>



-- 
Joe Audette
Software Solutions Architect
Source Tree Solutions, LLC
PO Box 621861
Charlotte, NC 28262
704.323.8225
joe.audette at gmail.com
http://www.sourcetreesolutions.com
http://www.mojoportal.com