Unable to download remote database
Last post May 24, 2012 06:42 AM by Dalong Zhang - MSFT
May 22, 2012 12:40 AM|MeButler|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.
May 24, 2012 06:42 AM|Dalong Zhang - MSFT|LINK
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