|
Question:
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. |
