[Mono-aspnet-list] MS SQL to MySQL

[Joe Audette]

oh and of course the .NET code would have to be changed to use the
MySql Connector for .NET, so there is more to it than just the data
migration.

On Sat, May 9, 2009 at 1:55 PM, Joe Audette <joe_audette at yahoo.com> wrote:
> 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
>



-- 
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