Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1716
  • Last Modified:

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

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
RobertNZana
Asked:
RobertNZana
  • 2
2 Solutions
 
David H.H.LeeCommented:
0
 
RobertNZanaAuthor Commented:
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
 
PianoEnCommented:
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
 
PianoEnCommented:
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

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now