I poked around Microsoft SQL website tonight and found this pretty cool. Especially, if your web hosting company doesn't provide the control panel that supports SQL management, you should load this as one of your management web tools on your website. It would really ease the pain on updating and changing the online SQL database.
The Web Data Administrator is a utility program implemented in ASP.NET that enables you to easily manage your SQL Server data wherever you are. Using its built-in features, you can do the following from Internet Explorer or your favorite Web browser:
- Create and edit databases in Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (MSDE)
- Perform ad-hoc queries against databases and save them to your file system
- Export and import database schema and data
download the web data administrator here