Link to home
Start Free TrialLog in
Avatar of slikrik98
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.!
ASKER CERTIFIED SOLUTION
Avatar of Evan Cutler
Evan Cutler
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial