Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shapper
Constraint Violating Yak Guru
450 Posts |
 Posted - 2008-09-30 : 00:31:09
|
| Hello,I created an SQL 2005 Express Database in VS 2008. I have the mdf file.What do I need to do to upload it to my hosting account?Is uploading the mdf file the best way to do this?Thanks,Miguel |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-30 : 02:54:16
|
| hi Miguel,Am assuming, you developed your app in asp.net webforms ? Well if its the case, you have many options. If you created and added the db in VS then the db will be placed in the app_data folder, but if you used MS SQL directly, then the db will be in management studio.1. If you used the app_data directory, then simply upload the data files to the remote server.2. If you its in the database, then you can either- Attach and detach as Tara said, but you will need admin permissions to the remote server.- Backup and restore |
 |
|
|
|
|
|
Upload Database