Hi, I have created a database using webmatrix, running SQLExpress. I have a production version and a local version. I am attempting to download the production version to my localhost, but get the following error: Unable to download remote database. I
have successfully deployed my locally hosted version to the production server. I found one piece of advice specifically for MySQL deployments, but can find no information related to this when running SQLExpress.
Has anyone encountered this before? I want to make an upgrade to the production database, but do not want to overwrite the data. So I am trying to copy the production data back into my local database so when I deploy the db changes, the production data
is not wiped out. Any and all advice is appreciated.
MeButler
1 Post
Unable to download remote database
May 21, 2012 11:40 PM|LINK
Hi, I have created a database using webmatrix, running SQLExpress. I have a production version and a local version. I am attempting to download the production version to my localhost, but get the following error: Unable to download remote database. I have successfully deployed my locally hosted version to the production server. I found one piece of advice specifically for MySQL deployments, but can find no information related to this when running SQLExpress.
Has anyone encountered this before? I want to make an upgrade to the production database, but do not want to overwrite the data. So I am trying to copy the production data back into my local database so when I deploy the db changes, the production data is not wiped out. Any and all advice is appreciated.
Thanks,
-Margaret
Dalong Zhang...
647 Posts
Microsoft
Re: Unable to download remote database
May 24, 2012 05:42 AM|LINK
Hi,
Why not do a database backup locally on your production server?
About how to export data to a remote server with SQL Express, you can refer to the following article:
Exporting data to a remote server with SQL Express
http://weblogs.sqlteam.com/jeffs/archive/2008/02/27/60539.aspx
Feedback to us
Develop and promote your apps in Windows Store