Last post Nov 13, 2007 11:20 AM by fishmore
Nov 08, 2007 10:26 AM|fishmore|LINK
I have my personal starter kit up and running on goDaddy. Now that I have expanded my local version and altered the local SQL express, How do I make the changes on the SQL database on goDaddy. I have
made tables on the SQL database, however I can't figure out how to add data such as picture ID's and URL's.
Shouldn't I be able to copy and paste into the query analyzer like I did originally when I set up the database connection?
Nov 08, 2007 07:17 PM|MaineOne|LINK
If you use Microsoft SQL Server Management Studio Express, you can generate scripts to run on the godaddy database.
Just right click on the Table or Stored Procedure, select Create to File, open the file created in notepad and copy then paste to query tool on godaddy account management page.(it has been awhile since I have been a godaddy customer, but this should point
you in the right direction)
Nov 09, 2007 03:02 PM|fishmore|LINK
But still no luck, I have right clicked every where and no option to create file. I even went as far as downloading the latest version of SQL 2005 and still nothing.
Nov 10, 2007 06:27 AM|MaineOne|LINK
Make sure you are using the Management Studio Express tool
SQL Server Management Studio Express is installed by running the setup program for either SQL Server Express with Advanced Services or SQL Server Express Toolkit. Before you install SQL Server Management Studio Express, you must install
Download ** (43.1 MB)
Then you should be able to create an sql file, which can be opened in notepad.
Your only other option would be to dump GoDaddy and go with a hosting plan that allows remote access to your databases. i would recommend
Nov 10, 2007 11:34 PM|whighfield|LINK
You will probably have to export the data out of your local database and import it onto your goDaddy database using SQL Scripts. You can find such a script here
http://www.robgonda.com/blog/files/robGonda/UserFiles/File/generate_inserts.txt. This is a stored procedure that will generate insert SQL statements for all of (or some) of the data in your tables. There are samples of how to use the stored procedure
in the actual stored procedure.
Nov 13, 2007 11:20 AM|fishmore|LINK
Thanks for the help. I am having a hard time understanding how to generate SQL statements. I am going to hard code my info for now. When it is time to renew with GoDaddy, I am going to drop them and move to a different
server that accepts remote connections.