The SQL Server Web Data Administrator - Page 2

February 25, 2005

Creating a new database

In order to create a new database, simply click the Create New Database link and enter the name of your new database. For example, create a database called Databasejournal, as shown in Figure D. Once the database is created, you can manage the objects by choosing the appropriate task, as shown in Figure E.

You can also view the objects by clicking Server Tools | Databases and choosing the database that you want to manage objects on. For example, if we click Server Tools | Databases | Pubs, we can view all the tables by choosing the appropriate link. Next, we can create a query and execute it for information as shown. Finally, we can run a quick backup if necessary, as shown in Figure F.

Exporting/importing a new database

Exporting and importing a database is just as simple as creating a database. Just select Server Tools | Export/Import and choose the database and objects. Once that is complete, click Export or Import as shown in Figure G. Remember to save the file to an appropriate place on your computer.

Creating logins and server roles

You can quickly create a login by choosing Server Tools | Security and then clicking the Security icon. Next, choose the Create New Login link on the right side of the screen (Figure H). You can also add and edit server roles (Figure I) by choosing the Roles icon.

Conclusion

In the age of 24 x 7 Web sites with no downtime, a DBA often needs a way to perform tasks quickly when off-site. The SQL Server Web Data Administrator is very powerful and gives you the ability to do a multitude of things with your SQL Server remotely. I recommend that you download it and give it a try.

» See All Articles by Columnist Steven S. Warren