GetMsSqlDump - a mysqldump-like tool for MSSQL

  •        82

GetMsSqlDump is the mssql counterpart (or something similar) of mysqldump, written for Microsoft SQL Server, in PowerShell. I'd call it mssqldump if it weren't in use. Using this script you can dump your database content into a file in a form of INSERT INTO statements.

http://getmssqldump.codeplex.com/

Tags
Implementation
License
Platform

   




Related Projects

ReportingServicesTools - Reporting Services Powershell Tools


This project contains PowerShell scripts that allows you to perform various operations with SQL Server Reporting Services. In order to use the scripts included in this project successfully, please download/clone the entire project as there are dependencies between the scripts.All of our scripts were written with the assumption that you will be executing them against SQL Server 2016 Reporting Services default instance (i.e. mssqlserver). However, we understand this may not be the case for you. So for each script, you will see that we have provided a way for you to specify the name and/or version of your SQL Server Reporting Services instance name. Sometimes the version of your SQL Server instance is also required. If you do not provide one, we will assume that you want to execute this against the default instance.

sqlBackupRestorePS - My simple MS Sql Server backup and restore Powershell script


My simple MS Sql Server backup and restore Powershell script

PowerShell Data Processing Extension for SQL Server Reporting Services


Plug this into SQL Server Reporting Services to create reporting based on your PowerShell scripts. The PowerShell DPE transforms your PowerShell output into a DataSet that can be consumed by SSRS.

SQL Power Doc


SQL Power Doc is a collection of Windows PowerShell scripts & modules that discover, document, & diagnose SQL Server instances & their underlying Windows OS.

Powershell4SQL


Module designed to simplify working with SQL Server from Powershell



SQL Server PowerShell Extensions


The primary goal of SQL Server PowerShell Extensions (SQLPSX) is to provide intuitive functions around the SMO objects which are backward compatible with SQL 2000. A secondary goal is to provide an application which reports flatten/effective security settings.

PowerShell-ETL-SQL-Server


PowerShell scripts for more object-oriented ETL than SSIS & remote SQL Server job initiation

SQL Server DB & SSIS Powershell Deployment


A lightweight way to automate SQL Server builds and deploy SSIS packages to development environments. Uses Red Gate SQL Compare, SVN and Powershell. Ideal for DW/BI projects.

Scripted PowerShell Automated Deployment Engine (SPADE) for SQL Server


SPADE simplifies the process of standing up a new SQL Server instance by applying standard Operating System pre-configurations, Installing SQL Server and then applying post-configurations and creating standard objects.

sql-xplat-cli - Repository for the new SQL cross-platform command line tools


We’re excited to introduce mssql-scripter, a multi-platform command line experience for scripting SQL Server databases.mssql-scripter is the multiplatform command line equivalent of the widely used Generate Scripts Wizard experience in SSMS. You can use mssql-scripter on Linux, macOS, and Windows to generate data definition language (DDL) and data manipulation language (DML) T-SQL scripts for database objects in SQL Server running anywhere, Azure SQL Database, and Azure SQL Data Warehouse. You can save the generated T-SQL script to a .sql file or pipe it to standard nix utilities (for example, sed, awk, grep) for further transformations. You can edit the generated script or check it into source control and subsequently execute the script in your existing SQL database deployment processes and DevOps pipelines with standard multiplatform SQL command line tools such as sqlcmd.

powerTrace - a PowerShell snapin for SQL Server Trace files


This is a snapin for Microsoft PowerShell which allows for the loading and exploration of SQL Trace files using PowerShell. This provider has been initially designed to work with trace files from SQL Server Analysis Services.

Scripts - Repository to store my scripts designed to be reusable in nature (powershell, sql etc….)


Repository to store my scripts designed to be reusable in nature (powershell, sql etc….)

poshsql - Powershell scripts for SQL DBA


Powershell scripts for SQL DBA

mssql-docker - Official Microsoft repository for SQL Server in Docker resources


This GitHub repository aims to provide a centralized location for community engagement. In here you will find documentation, Dockerfiles and additional developer resources.Visit the Microsoft Docker Hub page for more information and additional images.

Epmf - PowerShell: Enterprise Policy Based Framework for SQL Server


PowerShell: Enterprise Policy Based Framework for SQL Server

MSSQL Compressed Backup


MSSQL Compressed Backup compresses SQL Server 2000, 2005 and 2008 databases on the fly using bzip2, zip, or gzip compression. It saves the data in the standard SQL Server backup file format so that standard decompression and restoring tools can be us

Powershell-pasen


My bag of powershell script for miscellaneous purposes. Like backing up all sql server database that starts with eCM or run all sql script recursively in a directory tree.

SQL Server Central Management System


The SQLCMS uses and extends a series of features in SQL Server 2008 to manage and monitor SQL Server Instances, from versions 2000-2008. It is a series of modular components that also allows integration with other solutions such as MOM or OpenView installations.

sqlscripts - Various scripts for Oracle and SQL Server development


Various scripts for Oracle and SQL Server development

SQLSalt - SQL Server DBA Code and Helpful Scripts


SQL Server DBA Code and Helpful Scripts