Last post Dec 08, 2007 03:34 AM by rmdw
Dec 04, 2007 06:23 AM|rmdw|LINK
For the first time ever, I'm trying to publish my DB to GoDaddy's server. To do this I've been following these instructions: http://products.secureserver.net/products/hosting/PublishingWithDPW.htm
But in one of the steps it says that one MUST have a secure server connection with them. I do not. Does this mean that I must purchase this from them or is there another way to get my database from my local server up to their server?
Dec 07, 2007 05:00 AM|Benson Yu - MSFT|LINK
You can export the database objects to a file (assume named "personal-add.sql"); see the eighth step in your proveded article (Script mode:
Script to file).
Then log in your Godaddy Account Manager, open the Query Analyzer. Open the script file just exported and run it.
To Add Your "personal-add.sql" Schema to Your SQL Database
1. Log in to your Account Manager.
2. In the My Products section, select Hosting Account List.
3. Next to the hosting account you want to modify, click Open.
4. In the Databases section of the Hosting Control Center, click the SQL Server icon.
5. Next to the name of your SQL Server database, click Open Manager. The SQL Server Web Admin tool displays.
6. In the tree on the left, expand the Connection folder and select Connection.
7. Enter the User Name and Password for your database. You created your user name and password when you set up your SQL server.
8. Expand the Tools folder on the left and select Query Analyzer.
9. On your local computer, open the "personal-add.sql" file for your Personal Web site. This file is located in the "App_Data" folder, off the web project root.
10. Copy all of the content in the "personal-add.sql" file and paste it into the Query Analyzer section of your SQL Server Web Admin tool.
11. Click Submit.
This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience
to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there.
There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.
Dec 08, 2007 03:34 AM|rmdw|LINK
Thank you so much! It works great.
Tell me though, why is the Database Publishing Tool setup to not allow publishing if SSL isn't available? Surely that should be the user's choice? A warning could be provided but shouldn't it be allowed regardless?