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 <[email protected]> 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 <[email protected]> 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 >> [email protected] >> 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 > [email protected] > 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 [email protected] http://www.sourcetreesolutions.com http://www.mojoportal.com _______________________________________________ Mono-aspnet-list mailing list [email protected] http://lists.ximian.com/mailman/listinfo/mono-aspnet-list
