?
Solved

How attach SQL Express db to SQL Server (GoDaddy Hosting)

Posted on 2009-07-14
4
Medium Priority
?
1,694 Views
Last Modified: 2013-11-30
I have an ASP.NET web app that I developed locally using SQL Express.

I created a new empty SQL Server db on my GoDaddy hosting.  How can I "attach" the MDF?  I need the data structure and data in the new SQL Server db.

Thanks.
0
Comment
Question by:RobertNZana
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 29

Assisted Solution

by:David H.H.Lee
David H.H.Lee earned 400 total points
ID: 24856545
0
 
LVL 9

Author Comment

by:RobertNZana
ID: 24856552
I was looking for another alternative.  I already found that article.  I didn't want to download SQL Server 2008 to get it to work etc...
0
 

Accepted Solution

by:
PianoEn earned 1600 total points
ID: 24857191
Hi RobertNZana,

Try the following:
1. Script your mdf file as an sql file using Database Publishing Wizard.
2. Once you have the sql file, you can publish it to godaddy using the same program (DPW).
3. You can find the godaddy webservice and all other connection strings in your godaddy  account.

That should help, I had to go through the same procedure earlier this week.

If you need more assitance, I'd be glad to help.
0
 

Expert Comment

by:PianoEn
ID: 24859091
Another thing you can do, instead of step 3 is to log on to godaddy, and through the database management section, copy and paste your sql file (from step 1), and execute it directly on the web.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Originally, this post was published on Monitis Blog, you can check it here . It goes without saying that technology has transformed society and the very nature of how we live, work, and communicate in ways that would’ve been incomprehensible 5 ye…
This article is in regards to the Cisco QSFP-4SFP10G-CU1M cables, which are designed to uplink/downlink 40GB ports to 10GB SFP ports. I recently experienced this and found very little configuration documentation on how these are supposed to be confi…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question