Managing my SQL Server Database on a webserver
-
Hi all, I am asking this question becoz I've never uploaded a DB on a webhosting server. I am building a website that has a DB, from time to time I will need to add/remove tables from the database but I don't know if a typical webhosting service will provide me with tools to carry out such tasks or if I should write my own DDL code to add/remove tables, etc. Thanks alot
And ever has it been that love knows not its own depth until the hour of separation Mohammad Gdeisat
-
Hi all, I am asking this question becoz I've never uploaded a DB on a webhosting server. I am building a website that has a DB, from time to time I will need to add/remove tables from the database but I don't know if a typical webhosting service will provide me with tools to carry out such tasks or if I should write my own DDL code to add/remove tables, etc. Thanks alot
And ever has it been that love knows not its own depth until the hour of separation Mohammad Gdeisat
If a webhost provides you with a DB, they should also provide some mechanism to remotely manage it. Bit pointless otherwise (or just a poor ISP).
-
Hi all, I am asking this question becoz I've never uploaded a DB on a webhosting server. I am building a website that has a DB, from time to time I will need to add/remove tables from the database but I don't know if a typical webhosting service will provide me with tools to carry out such tasks or if I should write my own DDL code to add/remove tables, etc. Thanks alot
And ever has it been that love knows not its own depth until the hour of separation Mohammad Gdeisat
Host do not provide any interface to connect to database as these are external tools. You can connect to database using the same tool that you use to connect to your local database. For Eg: If you are using MS SQL server 2005 as Database, you will use SQL Server Management Studio to connect to remote Server. Difference is that ServerName: <IP Address of Database Server that you Used in Web.config> Authentication: SQL server Authentication Login: <ID Provided by your host or one you created> Password: <Same as you created or Provided by host> I used to connect to database of my website using the above method. Regards Aman Bhullar
-
Host do not provide any interface to connect to database as these are external tools. You can connect to database using the same tool that you use to connect to your local database. For Eg: If you are using MS SQL server 2005 as Database, you will use SQL Server Management Studio to connect to remote Server. Difference is that ServerName: <IP Address of Database Server that you Used in Web.config> Authentication: SQL server Authentication Login: <ID Provided by your host or one you created> Password: <Same as you created or Provided by host> I used to connect to database of my website using the above method. Regards Aman Bhullar
Thanks alot, you saved my life :-)
And ever has it been that love knows not its own depth until the hour of separation Mohammad Gdeisat