locked
MySql 5 migration questions RRS feed

  • Question

  • User-1514795968 posted

    I have developed an ASP.NET/Silverlight app using MSSQL 2008 R2.  In looking for a hosting solution I ran into the problem that the hosting providers I'm loooking at only offer SQL Server express, so there is a 10GB databsse limit, whereas they do offer MySQL 5 with no limit.

    I've searched Using MySQL with ASP.net and found a ton of inforamtion, too much in fact.

    What are some good links explaining how to migrate from MSSQL 2008 Express edition to MySQL 5?

    I'm concerned also about the tools avaiable to manage a MySQL 5 databse, currently I'm using SQL Server Management Studio and am happy with it.

    Any guidence apprechiated.

    On the other hand, are there any good hosting providers any one is aware of that offer the full version of SQL Server 2008 that has no practible upper limit on db size?  Price is consideration, of course, which is why most of the providers I've looks at only have the express verions, I suppose.

    Monday, June 13, 2011 11:20 AM

Answers

  • User-718146471 posted

    As far as a hosting suggestion, I could recommend DreamHost which is who I am going through. On their systems, they offer unlimited everything for just $10/month and offer you the first year for a killer price of only $3.00/month. I'm really happy with the hosting package I have with them.

    As far as migrating from SQL Server 2008 to MySQL, it can be rather tricky since there are differences in how you have to format your queries and use stored procedures. For the db management side of things, there is the PHP MyAdmin tool which manages MySQL Databases much like sql studio express. Of course, you'll also need to get your hands on the dot net mysql connector which lends its own set of headaches to get it working properly.

    So I guess your biggest hurdle is deciding what your monthly web budget is and where to go from here. I can try to help with the migration from SQL to MySQL but no guarantees of course :)

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, June 13, 2011 12:02 PM
  • User-718146471 posted

    One application I just ran across that could help you migrate is from http://dbconvert.com which I stumbled onto from http://willtomlinson.wordpress.com/2008/12/25/converting-your-sql-server-database-to-mysql/ 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, June 13, 2011 12:04 PM

All replies

  • User-718146471 posted

    As far as a hosting suggestion, I could recommend DreamHost which is who I am going through. On their systems, they offer unlimited everything for just $10/month and offer you the first year for a killer price of only $3.00/month. I'm really happy with the hosting package I have with them.

    As far as migrating from SQL Server 2008 to MySQL, it can be rather tricky since there are differences in how you have to format your queries and use stored procedures. For the db management side of things, there is the PHP MyAdmin tool which manages MySQL Databases much like sql studio express. Of course, you'll also need to get your hands on the dot net mysql connector which lends its own set of headaches to get it working properly.

    So I guess your biggest hurdle is deciding what your monthly web budget is and where to go from here. I can try to help with the migration from SQL to MySQL but no guarantees of course :)

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, June 13, 2011 12:02 PM
  • User-718146471 posted

    One application I just ran across that could help you migrate is from http://dbconvert.com which I stumbled onto from http://willtomlinson.wordpress.com/2008/12/25/converting-your-sql-server-database-to-mysql/ 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, June 13, 2011 12:04 PM