SQL Admin Studio

SQL Admin Studio is a strong SQL Database Management program. It is a complete management solution for System Administrator's and Developers. Designed to be fast, intuitive and powerful with code generation templates automating every day tasks.

SQL Admin Studio currently supports the management of the following Database Servers:- ￭ Microsoft SQL Server 2000 ￭ Microsoft MSDE Server 2000 ￭ Microsoft SQL Server 2005 & Microsoft SQL Express ￭ Microsoft Access ￭ MySQL 4.0

Here are some key features of "SQL Admin Studio":

￭ Connect to Local & Remote Servers ￭ Write SQL Script ￭ Browse Database Schema ￭ Remember Server Connection Details ￭ Open Tables ￭ Edit Table Data ￭ Open Views ￭ Design Stored ProceduresTriggersViewsFunctions ￭ Execute Templates ￭ Browse Database Schema with the Schema Window ￭ Syntax Highlighting ￭ Dockable Windows with Drag & Drop ￭ Design Tables, Rename Columns, Reorder Columns, Set Primary Keys, Set Identity Columns, Add/Remove Columns, Set Default Values ￭ Create/Edit/Drop SQL Logins ￭ Create/Edit/Drop SQL Users ￭ Create/Edit/Drop Table Indexes ￭ Create/Edit/Drop Table Check Constraints ￭ Create/Edit/Drop Table Foreign Keys ￭ Export Data to Excel, Csv, Xml Dataset and SQL Script ￭ Import Data from Xml Dataset ￭ Backup SQL Server Database ￭ Restore SQL Server Database ￭ Script Intellisense ￭ Design User Code Templates ￭ Convert Tables between SQL, MSDE, EXPRESS, Access & MySQL including data using XML Export & Import functions ￭ Drag & Drop Objects from the Schema Window to the Script Window ￭ Compare SQL Server Database Schema and Synchronise the changes ￭ View Large Text Columns ￭ Import Data Across SQL Servers