slikrik98
asked on
ASP.Net/SQLServerExpress + Godaddy Hosting = can't deploy
Greetings,
This is one of those rare questions that I've seen asked THOUSANDS of times on the internet with no *good* solution (you may or may not agree with the latter portion of my claim). Namely, trying to port a website created on my local dev machine using SQLServer Express to Godaddy hosting, which does not use Express, and forbids the attaching of .MDF files. I've spent a good deal of time creating various roles for my application, various users, access-rights, etc., and now I can't recreate the db structure on Godaddy's SQL Server.
Here are some of the things I've tried:
A) installing SQL Server Management Studio Express: I thought perhaps I could "open" my .MDF file in this application and export the db structure as a .SQL file, which I could then import into Godaddy. This did not work -- I was unable to open (or attach) the .MDF file in question, even though it is ASP.NET. I am basically starting from an MSDN sample website (Personal Website sample). This generates an .MDF file. When I open SQL Srv Mgt Studio Express, I see an aspnetdb, however this is not the one that is created by my application (I'm assuming this is my computers "general" db or something). These tables have no rows, etc. So I thought I could attach my .MDF file to this empty aspnetdb that is showing up in the Management Studio, however I get error messages when I try to attach it.
B) manually recreating the rows in the Godaddy server, but this has two problems: 1 - I have no way of seeing the data in my .MDF file because of (A), and 2 - I don't think I can manually enter in the passwords for users.
Basically I need a way to transfer the data in my .MDF file (the roles and their access rights are really the most important thing) to the Godaddy server. I've seen some people try to sell their product which will essentially attach the .MDF file for you, but I can't imagine there's not way to do it for free. Any help is greatly appreciated.!
This is one of those rare questions that I've seen asked THOUSANDS of times on the internet with no *good* solution (you may or may not agree with the latter portion of my claim). Namely, trying to port a website created on my local dev machine using SQLServer Express to Godaddy hosting, which does not use Express, and forbids the attaching of .MDF files. I've spent a good deal of time creating various roles for my application, various users, access-rights, etc., and now I can't recreate the db structure on Godaddy's SQL Server.
Here are some of the things I've tried:
A) installing SQL Server Management Studio Express: I thought perhaps I could "open" my .MDF file in this application and export the db structure as a .SQL file, which I could then import into Godaddy. This did not work -- I was unable to open (or attach) the .MDF file in question, even though it is ASP.NET. I am basically starting from an MSDN sample website (Personal Website sample). This generates an .MDF file. When I open SQL Srv Mgt Studio Express, I see an aspnetdb, however this is not the one that is created by my application (I'm assuming this is my computers "general" db or something). These tables have no rows, etc. So I thought I could attach my .MDF file to this empty aspnetdb that is showing up in the Management Studio, however I get error messages when I try to attach it.
B) manually recreating the rows in the Godaddy server, but this has two problems: 1 - I have no way of seeing the data in my .MDF file because of (A), and 2 - I don't think I can manually enter in the passwords for users.
Basically I need a way to transfer the data in my .MDF file (the roles and their access rights are really the most important thing) to the Godaddy server. I've seen some people try to sell their product which will essentially attach the .MDF file for you, but I can't imagine there's not way to do it for free. Any help is greatly appreciated.!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.