Hello, I am a COMPLETE noobie. I am using visual web developer 2005 and a template website for a club. This template uses two sql server express databases (from what I understand); aspnet.mdf (for the user data / permissions, etc.), and my application
(content) database. I got the website compiling without error on my local machine. I purchased hosting from DiscountASP.net, which was a featured provider on the asp.net forums and downloads sites. I was allowed by my club to purchase one sql server access
from the host for an additional $10/month. The website does not work on the host, I found out due to only the aspnetdb.mdf file being uploaded to the sql server on the host. I have been told I need to MERGE the aspnetdb.mdf and my club.mdf databases into
one and then install it on the host sql server. My question is how to do this? I have been told to use the sql server management studio express, do this and that (like what is told in this forum) and all will be right with the world. I cannot get past how
to make this management tool to see my database in the first place. Could someone please help me?! I was given control of my club's website a week ago and told not to have it down too long, so I am under a time crunch.
rcflyerb
Member
6 Points
16 Posts
Re: How to import an mdf file into SQL Server Management Studio Express?
Mar 12, 2008 01:42 AM|LINK
Hello, I am a COMPLETE noobie. I am using visual web developer 2005 and a template website for a club. This template uses two sql server express databases (from what I understand); aspnet.mdf (for the user data / permissions, etc.), and my application (content) database. I got the website compiling without error on my local machine. I purchased hosting from DiscountASP.net, which was a featured provider on the asp.net forums and downloads sites. I was allowed by my club to purchase one sql server access from the host for an additional $10/month. The website does not work on the host, I found out due to only the aspnetdb.mdf file being uploaded to the sql server on the host. I have been told I need to MERGE the aspnetdb.mdf and my club.mdf databases into one and then install it on the host sql server. My question is how to do this? I have been told to use the sql server management studio express, do this and that (like what is told in this forum) and all will be right with the world. I cannot get past how to make this management tool to see my database in the first place. Could someone please help me?! I was given control of my club's website a week ago and told not to have it down too long, so I am under a time crunch.
Please help!
Bryan Saldana