Skip to content

Cool SQL Server and SQL Express Command-Line Utility

February 16, 2010

It is free and you can download it here.

It includes a useful doc-file that walks-through the various commands it provides.  I also found this link useful in walking through how to use common SQL commands for creating new databases.

Here is a simple set of steps that demonstrate how to use it to create a SQL Express database file, attach to it, create a database in it, then add a table, then add values into the table, then do a select query against it (note: all commands I typed are in bold below):

C:\SQLUtility>sseutil -c

Console mode. Type ‘help’ for more information.

1> !create c:\sqlutility\testing123.mdf
Command completed successfully.
1> !attach c:\sqlutility\testing123.mdf
Command completed successfully.
1> use "c:\sqlutility\testing123.mdf"
2> go
Command completed successfully.
1> create database people
2> go
Command completed successfully.
1> use people
2> go
Command completed successfully.
1> create table names
2> (id INTEGER NOT NULL,
3> name VARCHAR(50) NOT NULL)
4> go
Command completed successfully.
1> insert into names values(1, 'bill gates')
2> go
1 row(s) affected.
1> select * from names
2> go
id   name
------------------
1  bill gates
1 row(s) affected.
1> quit

Of course, an easier way to-do this from scratch would be to use Visual Web Developer or VS 2005 and select Add New Item->Database file, name it, and then use the server explorer to create and add the table.  But the nice thing about the above approach is that you can use it execute a SQL script file to quickly create/re-create your database without needing a tool on your system (or a user who knows how to use it).

P.S. One other cool thing about this utility is that it allows you to list all databases you have installed on your system.  Just type sseutil –l to list all of the databases and .mdf files being used.  This is very helpful if you have multiple database instances on your system (for example: I have some SQL 2000 databases and some SQL 2005 Express ones).

Thanks to ScottGu

From → Iptek, Opini

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: