How to add new columns in already hosted database?

Question

User1508434899 posted

 Hi,

i have hosted my Site..

now i have added few columns & new tables in my database prsent locally..

how can i do this changes to my already hosted database ? ( i dnt want to loosed data)

i use sql server 2005

Answer 1

User1589032278 posted

you have two ways to do that depending on your hoster facilities, one of them if your web site hoster provide you with remotly connection to your database open your life one by using SQL Server Managment Studio and update tables and records as needed as how you do in your local machine....

the other option that some of web site hosting companies provide you with a 3rd party database connection tool, where you can login and had same feature to SSMS to use and modify your database..

Answer 2

User1508434899 posted

you have two ways to do that depending on your hoster facilities, one of them if your web site hoster provide you with remotly connection to your database open your life one by using SQL Server Managment Studio and update tables and records as needed as how you do in your local machine....

the other option that some of web site hosting companies provide you with a 3rd party database connection tool, where you can login and had same feature to SSMS to use and modify your database..

 

thank you. I did it just like you except I took backup of my database

which is hosted. I did changes in SSMS & restored it.