How do I download, install and setup ExpressSQL?

Answer: There are many applications available for direct access to your SQL server and the databases it contains.  Some applications come with the full version of SQL Server and others are available on the internet form various vendors.

ExpressSQL is a program we developed for users to manage SQL databases and for scheduling unattended backups.  It is a very powerful tool and a must-have for users of SQL Express Edition.  It can also be used for building queries and managing data including bulk deleting of data.

You can download ExpressSQL trial version free from our website – click here to download.

Once you download ExpressSQL to your hard drive, run the install program you downloaded.  The file name is ExpressSQL_Setup.exe.  Follow the steps to installing the program.

The install program will create a shortcut on the desktop under Programs / Express Technology.  Select and run ExpressSQL.

When ExpressSQL opens, you will need to register your SQL Server.  Click on File / New Server Registration and the following dialog will appear:

Enter the applicable information for your server.  You will need to know the sa (system administrator) password.  Once the information is entered, click Save.

The server name will appear in the upper left list.  Click on the server name and ExpressSQL will then attempt to connect to the server.  If the server connection fails, check your information entered including the sa password.  It is important that you enter correct information and that network permissions allow for the connection.

Once the connection is successful the databases for that server will be listed below the server name.  Click on the ExpressMaintenance database to connect to it as shown below.

You can then use ExpressSQL to perform queries, bulk updates and deletes of data.  You can also view table schemas and other important information.  There are also options for scheduling backups, importing data, rebuilding indexes and many more functions.

The SQL query language is very powerful and virtually unlimited in features that allow you to query and manipulate data.  Use caution when updating or deleting data and backup your data first.

If you wish to learn more about the SQL language visit the following link: How can I learn more about MS SQL Server?

The screen shot below reflects a query to the Units table with a where clause.

Please see the ExpressSQL application help for complete datails on program features.