I've been playing around with asp .net and SQL Server 2005 Express locally for the past few months. Recently I signed up for a Godaddy shared hosting account. When uploading my files, I found out that I can't just upload my .mdf data files from SQL. I would have to create my own database manually through Godaddy's account. I also saw some programs online that will convert my database into a .sql script file which I can then upload.
Anyway, I was looking around at other hosting companies, and I saw the DiscountASP offers a tool called Real-Time SQL 2005 Attach MDF File. With this tool, can I simply upload my .mdf files to the hosting account's database? Is there some other caveat? Would I be able to connect to hosting database through SQL Server Management Studio Express and make changes to that database through that program?
I'm probably going to stick with GoDaddy for now, because my database is very simple, and I'm just testing things out, but this mdf file attach tool that DiscountASP offers looks to be very helpful in uploading data files and making changes on the fly through Management Studio.
For anyone using DiscountASP, please let me know your thoughts.
Thanks.