Solved

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

Posted on 2009-07-14
4
1,584 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
  • 2
4 Comments
 
LVL 29

Assisted Solution

by:David H.H.Lee
David H.H.Lee earned 100 total points
Comment Utility
0
 
LVL 9

Author Comment

by:RobertNZana
Comment Utility
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
Comment Utility
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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This is an article about my experiences with remote access to my clients (so that I may serve them) and eventually to my home office system via Radmin Remote Control. I have been using remote access for over 10 years and have been improving my metho…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

762 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

Need Help in Real-Time?

Connect with top rated Experts

5 Experts available now in Live!

Get 1:1 Help Now