What is the best way for update my database?

Hello friends,

I'm quite new in internet developments, and I wonder what is the best way for doing changes to my database.
I have a site that has an online shop, but sometimes I need to add several new products, delete others and so on.

Currently, I stop my site, download and update the database and then upload it again.

I think this process is too primitive!!!...I think I can make a Windows application that connects directly to the site's database.

Whay do you suggest me?

Thanks a lot.
 
Beside the built-in control panel for this task, You can use OLAP and OLTP services as allmost all databases now a days support online analytical and tranjection processing, hence you can connect your live database through some client and update it.

This can easily be done through database queries using any query language supported by the query processor of that specific databse type.
 
Back
Top