SqlDump - Microsoft SQL Server database backup program
Latest stable release is v2.2.1
Current version is v3.0b1
SqlDump is a program to backup a Microsoft SQL Server database as a text
file. SqlDump generates SQL statements for tables, indexes, user-defined
types, views, procedures, etc and also the table data. This data can be
used for a variety of purposes, such as database backups, moving databases
to another server, or setting up a test database based on the contents of
an existing database.
Output for each dumped table consists of a create table statement that
re-creates the table, followed by a set of insert statements that reload
the contents of the table.
Major changes from 2.2.1 to 3.0b1
- SqlDump Database Dump Wizard now displays the list of databases for
- SqlDump Database Dump Wizard now has an "About" button for displaying
- FIXED: incorrect dumping of timestamp/uniqueidentifier columns.
- FIXED: object names, column names will not be delimited by brackets
if they comply with identifier naming rules (more support for MS SQL 6.5
- FIXED: table not being dumped if it does not have any indexes.
- FIXED: database size incorrectly calculated.
- FIXED: crash if password input is greater than 64 characters (buffer
- FIXED: keyboard accelerators, tab key was not working in the progress
- FIXED: hitting Ctrl+C in password input in SqlDump command line
- A log file named "database-name.log" is created in the temp directory
(C:\TEMP or wherever defined). SqlDump Database Dump Wizard displays a
'View Log' button for viewing the log file.
- No more Wizard97 style, SqlDump Database Dump Wizard has now a normal
wizard look and feel.
- SqlDump (both gui and command line programs) now asks for
confirmation before overwriting an existing file (the log file will
always be overwritten).
- SqlDump command line now supports GNU style long options.
- Renamed getpass to getpw.
- Moved SQL utility functions like quote(), escape(), etc. to
sqlutil.c. The function mtof() is no longer needed, strtod() does a
better job actually.
- SqlDump now compiles successfully under MinGW too. That makes SqlDump
support three Win32 implementations viz., Microsoft Visual C++, Borland
C++, and MinGW with W32 headers and libraries.
- All the source files have been fully modified to follow my coding
style (based on the classic Bjarne Stroupstrup's coding style).