Skip to content

Command line tool to export a MSSQL database as a set of SQL statements

Notifications You must be signed in to change notification settings

daniel-jann/sqlserverdump

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

21 Commits
 
 
 
 
 
 

Repository files navigation

Project Description

SQL Server Dump (sqlserverdump) is a command line utility inspired by mysqldump. It allows to dump SQL Server databases and their content as SQL statements. It's written in C#.

The creator's initial aim was to be able to backup databases in a non-binary format. Microsoft's backup tools create binary files which can be restored pretty much only on a server having the same version as the one on which the backup has been made. The goal with this project is to be as much as possible independant of the server's version.

The project makes use of SQL Server Management Objects (SMO) in order to generate the SQL statements. It will therefore require that library. If have SQL Server 2008 installed you should be fine. If you have a lower version, you will probably have to install the Shared Management Objects which you will find in the Microsoft® SQL Server® 2008 R2 SP1 Feature Pack. That one has several requirements. It will probably tell you to install the CLR Types (SQLSysClrTypes) first. (Choose the files from the architecture that matches yours: IA64 = Itanium, x64 = Windows 64 bits, x86 = Windows 32 bits)

Currently, only features of SQL Server up to 2008 are meant to be supported. That is, it will probably work with newer versions but you won't be able to dump the new features of these versions (things like SEQUENCE, ...)

This project's code was originally hosted on http://sqlserverdump.codeplex.com/

About

Command line tool to export a MSSQL database as a set of SQL statements

Topics

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages