Solved

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

Posted on 2009-07-14
4
1,638 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 100 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 400 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

Why Off-Site Backups Are The Only Way To Go

You are probably backing up your data—but how and where? Ransomware is on the rise and there are variants that specifically target backups. Read on to discover why off-site is the way to go.

Question has a verified solution.

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

Suggested Solutions

If your business is like most, chances are you still need to maintain a fax infrastructure for your staff. It’s hard to believe that a communication technology that was thriving in the mid-80s could still be an essential part of your team’s modern I…
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
Viewers will learn how to connect to a wireless network using the network security key. They will also learn how to access the IP address and DNS server for connections that must be done manually. After setting up a router, find the network security…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

739 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