Last post Jun 13, 2011 12:04 PM by bbcompent1
Jun 13, 2011 11:20 AM|michaelliveone|LINK
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.
Jun 13, 2011 12:02 PM|bbcompent1|LINK
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 :)
Jun 13, 2011 12:04 PM|bbcompent1|LINK
One application I just ran across that could help you migrate is from
http://dbconvert.com which I stumbled onto from