but yes, another godaddy question. i have a client with a site hosted by godaddy. i created a site, and could not get database publishing wizard to run the sql statment on the server to create database tables, views, data, etc. godaddy told me they did
not allow for remote access to their sql server databases. they told me the only way to upload a database was through the hosted site owners' hosting control center, which is a username/password signed in screen off godaddy's website. this has to be Bull$4it,
as i find it hard to believe that the owner of every site ever hosted by godaddy has uploaded their own database. so i used database publishing wizard to create the .sql file, and downloaded from microsoft the .aspx file to run the script for me. i adjusted
the filename and connection string in the aspx file, uploaded both through his ftp, and navigated to the page through internet explorer and i got a 404 not found error, like somehow it is being blocked. believe me i double and triple checked everything, with
no luck. my customer is not at all familiar with computers, to the point that i put the sql file on a cd and gave it to him, and he could not figure out to upload and run the sql statement from his godaddy hosting control center. i sadly had to have him over,
have him login to his personal godaddy account (while i covered my eyes like i was 12) and then i spent 30 seconds uploading and executing the query. WHAT UTTER MADNESS!!!!!!!!!!!!!
well now i have an update for the site ready to go, and NO WAY do i want to go through this again with the new tables. anybody with prior godaddy experience who has a workaround PLEASE help me out here!!
Actually godaddy has a SQL Server Web Admin tool. You can first use “Database Publishing Wizard” utility to script the database objects to a file, and then run the T-SQL code in the SQL Server Web Admin tool.
For more information, please refer to my reply in the following thread:
Sincerely,
Benson Yu
Microsoft Online Community Support
Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
Marked as answer by doKtorhallam on Dec 19, 2007 12:24 PM
thank you my friend for the help, but it is not what i need.
i am aware of your steps and have done this already. the problem is that this is not my account, i have built the site for someone else, and need a way to upload the database tables without having this other person come over and login to their hosting control
center so i can upload the needed sql file. godaddy has told him that this is the only way they allow because of security purposes, so for now i guess this is the way we have to do it.
but i do appreciate your response, and it could be very helpful to anyone who is trying to upload a database and is the account owner, i will mark you as answer for this reason and for your attempt at helping me out. thanks again.
doKtorhallam
Member
251 Points
222 Posts
trouble moving SQL database to godaddy
Dec 15, 2007 03:36 AM|LINK
i know, not another godaddy question!!!!!
but yes, another godaddy question. i have a client with a site hosted by godaddy. i created a site, and could not get database publishing wizard to run the sql statment on the server to create database tables, views, data, etc. godaddy told me they did not allow for remote access to their sql server databases. they told me the only way to upload a database was through the hosted site owners' hosting control center, which is a username/password signed in screen off godaddy's website. this has to be Bull$4it, as i find it hard to believe that the owner of every site ever hosted by godaddy has uploaded their own database. so i used database publishing wizard to create the .sql file, and downloaded from microsoft the .aspx file to run the script for me. i adjusted the filename and connection string in the aspx file, uploaded both through his ftp, and navigated to the page through internet explorer and i got a 404 not found error, like somehow it is being blocked. believe me i double and triple checked everything, with no luck. my customer is not at all familiar with computers, to the point that i put the sql file on a cd and gave it to him, and he could not figure out to upload and run the sql statement from his godaddy hosting control center. i sadly had to have him over, have him login to his personal godaddy account (while i covered my eyes like i was 12) and then i spent 30 seconds uploading and executing the query. WHAT UTTER MADNESS!!!!!!!!!!!!!
well now i have an update for the site ready to go, and NO WAY do i want to go through this again with the new tables. anybody with prior godaddy experience who has a workaround PLEASE help me out here!!
thanks in advance for any responses.
-sleepless in godaddyland
doKtorhallam
Member
251 Points
222 Posts
Re: trouble moving SQL database to godaddy
Dec 15, 2007 04:43 PM|LINK
anyone please?
Benson Yu - ...
All-Star
34797 Points
2497 Posts
Re: trouble moving SQL database to godaddy
Dec 19, 2007 08:23 AM|LINK
Hi doKtorhallam,
Actually godaddy has a SQL Server Web Admin tool. You can first use “Database Publishing Wizard” utility to script the database objects to a file, and then run the T-SQL code in the SQL Server Web Admin tool.
For more information, please refer to my reply in the following thread:
Trying to Publish SQL Server Database to GoDaddy Server
http://forums.asp.net/p/1189637/2048087.aspx
Benson Yu
Microsoft Online Community Support
Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
doKtorhallam
Member
251 Points
222 Posts
Re: trouble moving SQL database to godaddy
Dec 19, 2007 12:23 PM|LINK
thank you my friend for the help, but it is not what i need.
i am aware of your steps and have done this already. the problem is that this is not my account, i have built the site for someone else, and need a way to upload the database tables without having this other person come over and login to their hosting control center so i can upload the needed sql file. godaddy has told him that this is the only way they allow because of security purposes, so for now i guess this is the way we have to do it.
but i do appreciate your response, and it could be very helpful to anyone who is trying to upload a database and is the account owner, i will mark you as answer for this reason and for your attempt at helping me out. thanks again.