Last post Sep 10, 2009 01:58 AM by Enroth
Sep 09, 2009 09:55 AM|ankit_sam2001|LINK
I have a ASP.NET project witt MSSQL server 2005 database ( having database diagrams , Procedures and Tables)
I want to host the project online. How to setup database ? Either
1) By creating sql queries and running on server ( But the Peoblem is database diagrams), Or
2) Is there any way i can directly upload my .mdf database file? ( Will someone be able to download the database then? like www.mywebsite.com/database/data.mdf)
3) Is there any other way?
MS SQL server 2005
ASP .NET Hosting
Sep 09, 2009 10:36 AM|hajan|LINK
Well, The hosting provider may have some tools that may help you on that.
You can either upload your .mdf / .bak files and if you have access just restore on your dbms on the hositng server or tell the technical support of the hosting provider to do that for you.
Another way is to use MSSQL Enterprise Manager.
To connect to your database using SQL Enterprise Manager, go to New SQL Server Registration. Enter the IP address given to you by the hosting provider and select
Connect using SQL server login.
Enter your database username and password and click Connect.
Hope this helps,
Sep 09, 2009 10:36 AM|HostingASPNet|LINK
You should upload your database file in the /App_Data folder. (it has special permissions, so nobody could download your files). After that you could attached it on the fly. Check you hosting company for more info about how to deploy SQL database on their
Sep 10, 2009 01:58 AM|Enroth|LINK
Decent hosts like Dotnetpark have control panels allowing you to upload your database backup and restore it on the hosting server. It is for shared hosting. If you have a VDS like me you can upload
and restore it without any control panel.