Upload database that is not in App_Data folder

[Mr Friday]

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.

[Mr Friday]

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_Da ta.mdf: Cannot open file "C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\myDatabase_Da ta.mdf". Access is denied

Can someone suggest what I am doing wrong please?

[Mr Friday]

Sorry never mind I was making a basic error.