Upload database that is not in App_Data folder

Discussion in 'Databases' started by Mr Friday, Jul 31, 2010.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. On my local machine the SQL database that my local application uses is not stored in the app_data folder, it is instead located in the MSSQL folder.

    I would like to know which method / tool to use to transfer my local .mdf file up to my webspace so I can attach it to my website?

    I cannot use the copy website tool in Visual Studio to do this as my database .mdf file does not show up in the source pane as it is not stored in the app_data folder of my local web application.
     
  2. Ok, I tried to upload my local database using WISE-FTP application.

    I can successfully connect to my webspace using my FTP login credentials but when I try to upload my .mdf file I get the error message :

    ! Unable to open local file C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\myDatabase_Data.mdf: Cannot open file "C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\myDatabase_Data.mdf". Access is denied

    Can someone suggest what I am doing wrong please?
     
  3. Sorry never mind I was making a basic error.
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page