Script SQL Server Configuration

  •        94

Script SQL Server configuration information in a format suitable for DR purposes or checking into a source control system.

http://scriptsqlconfig.codeplex.com/

Tags
Implementation
License
Platform

   




Related Projects

ScriptDB


ScriptDb is a simple console app written in C# that uses SQL Management Objects (SMO) to script all the objects in a database. It will work against any SQL Server 2000 or 2005 database. It creates a directory tree structure with a similar hierarchy to that in Object Explorer i...

ExportSQLScript - Export MS SQL 2008R2/2008/2005/2000 objects to script


Command line driven utility to export MS SQL objects to script files suitable for database creation and revision control. Uses 2008R2 Server Management Objects (SMO) which are compatible with SQL Server 2000, SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.

Scriptio - A SQL Server Object Scripting Utility


A utility for generating object scripts for Microsoft SQL Server. It is specifically designed to script DROPs and CREATEs in the same script.

DbDiff: Database Diff and Database Scripting


Compare MSSql database structures. (Sql 2005, Sql 2008, Sql 2008R2, Sql Denali ) Features: - compare database structures - scripting without dmo or smo - commandline scripting, commandline compare - standalone dll-s for referencing



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.

SQL Compact data and schema script utility


This console app and SQL Server 2008 Management Studio add-in helps you better manage your SQL Compact development efforts. It allows you to script schema and data to a .sql file, which can be used in any context. It also scripts DML for use in SSMS scripts.

Support Vector Machines Data Mining Plug-in in Analysis Services


The datamining Support Vector Machine (SVM) plug-in in MS SQL Server Analysis Services 2008. This plug-in is the SVM classification algorithm in addition to the shipped data mining algorithms with SQL Server.

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.

Microsoft SQL Server Product Samples: Engine


This project contains Engine samples released with Microsoft SQL Server product.

SQL Data Capture - Black Box Application Testing


A tool for capturing and analyzing data modifications; an audit trail generator with a data modifications viewer. Helps with testing, troubleshooting and exploring application functionality. ASP.NET 3.5 C#, SMO application. Audit and CRUD generators are included.

SQL Server File System Tools


This is a collection of file system tools implemented as SQL CLR assemblies. Includes, Storing files in database raw, encrypted or compressed. Extracting said files back to disk or as record set, if Extracted compressed it is a zip file that any tool/windows can open, and more!

SQL Scriptz Runner


Features are : Drag And Drop script files Run a directory of script files Sql Script out put messages during execution Script passed or failed that are colored green and red (yellow for running) Stop on error option Open script on error option Run report with time taken...

GraphView - GraphView is a DLL library that enables users to use SQL Server or Azure SQL Database to efficiently manage graphs


GraphView is a DLL library that enables users to use SQL Server or Azure SQL Database to manage graphs. It connects to a SQL database locally or in the cloud, stores graph data in tables and queries graphs through a SQL-extended language. It is not an independent database, but a middleware that accepts graph operations and translates them to T-SQL executed in SQL Server or Azure SQL Database. As such, GraphView can be viewed as a special connector to SQL Server/Azure SQL Database. Developers will experience no differences than the default SQL connector provided by the .NET framework (i.e., SqlConnection), only except that this new connector accepts graph-oriented statements.GraphView is a DLL library through which you manage graph data in SQL Server (version 2008 and onward) and Azure SQL Database (v12 and onward). It provides features a standard graph database is expected to have. In addition, since GraphView relies on SQL databases, it inherits many features in the relational world that are often missing in native graph databases.

sql-server-samples - Official Microsoft GitHub Repository containing code samples for SQL Server


This GitHub repository contains code samples that demonstrate how to use Microsoft's SQL products including SQL Server, Azure SQL Database, and Azure SQL Data Warehouse. Each sample includes a README file that explains how to run and use the sample.Note that certain features like In-Memory OLTP are edition specific for SQL Server and would be possible to implement if the edition which supports that feature is being used to run the sample.

RSBuild SQL Server Reporting Service Deployment Tool


RSBuild currently supports two types of tasks: executing SQL Server scripts and publishing SQL Server Reporting Serivce reports and shared data sources. It uses ADO.NET to execute database scripts in batch. Database script can be specified in the configuration file with speci...

FileSystemHelper SQL Server CLR


FileSystemHelper SQL Server CLR provides a collection of CLR stored procedures and functions for interacting with the file system. Using these stored procedures and functions will allow you to avoid enabling xp_cmdshell on your SQL Server instances.

Big SQL Script File Runner


Here's project that enables any developers or others to run the big sql script file greater than 300MB or any size. It also supports rollback feature & others.

SQLbuddy – Microsoft SQL Server Management Tool


SqlBuddy is a tool for use with Microsoft SQL Server and MSDE, written in csharp/ DotNet (.NET), to facilitate SQL script writing. It is serves a slightly different purpose that of Query Analyser, in that it is aimed to *help* the user write SQL. It helps to explore the database schema, Organise SQL code and snippets, To expose the in-built SQL Server functionality (functions, procedures etc) to the developer.

Allocation SQL Server Management Studio Add-in


This is add-in for SQL Server Management Studio (SSMS) to display database allocation information. It builds on allocation information displayed by SQL Internals Viewer to show how data is allocated in SQL Server files. The add-in also displays information on space usage, ta...