Microsoft SQL Server Community Samples: Scripts

Project License Changed

Fri, 30 Nov 2007 19:40:26 GMT

Microsoft Public License (Ms-PL) This license governs use of the accompanying software. If you use the software, you accept this license. If you do not accept the license, do not use the software. 1. Definitions The terms "reproduce," "reproduction," "derivative works," and "distribution" have the same meaning here as under U.S. copyright law. A "contribution" is the original software, or any additions or changes to the software. A "contributor" is any person that distributes its contribution under this license. "Licensed patents" are a contributor's patent claims that read directly on its contribution. 2. Grant of Rights (A) Copyright Grant- Subject to the terms of this license, including the license conditions and limitations in section 3, each contributor grants you a non-exclusive, worldwide, royalty-free copyright license to reproduce its contribution, prepare derivative works of its contribution, and distribute its contribution or any derivative works that you create. (B) Patent Grant- Subject to the terms of this license, including the license conditions and limitations in section 3, each contributor grants you a non-exclusive, worldwide, royalty-free license under its licensed patents to make, have made, use, sell, offer for sale, import, and/or otherwise dispose of its contribution in the software or derivative works of the contribution in the software. 3. Conditions and Limitations (A) No Trademark License- This license does not grant you rights to use any contributors' name, logo, or trademarks. (B) If you bring a patent claim against any contributor over patents that you claim are infringed by the software, your patent license from such contributor to the software ends automatically. (C) If you distribute any portion of the software, you must retain all copyright, patent, trademark, and attribution notices that are present in the software. (D) If you distribute any portion of the software in source code form, you may do so only under this license by including a complete copy of this license with your distribution. If you distribute any portion of the software in compiled or object code form, you may only do so under a license that complies with this license. (E) The software is licensed "as-is." You bear the risk of using it. The contributors give no express warranties, guarantees or conditions. You may have additional consumer rights under your local laws which this license cannot change. To the extent permitted under your local laws, the contributors exclude the implied warranties of merchantability, fitness for a particular purpose and non-infringement.

NEW POST: Running this utility on all the databases and automating it

nuanw — Mon, 27 Aug 2007 20:15:08 GMT

If you're inquiring about the source code of the utility, you can either getting it from the release (Release Tab) or download the source code (Source Code Tab). You’ll get a zip file. Unzip the file, the source code is located at “..\DBScript Utility\Source”. Open “Script Utility.sln” in Visual Studio and compile the project and you’ll get “DBScript Utility.exe”.

vipultshah wrote:
Do you have a code behind this utility? I am interested in running this utility on all the User databases to generate separate script for Non-clustered and Clustered INdexes. Thanks

Vipul

NEW POST: Running this utility on all the databases and automating it

vipul_t_shah — Thu, 23 Aug 2007 16:29:05 GMT

Do you have a code behind this utility? I am interested in running this utility on all the User databases to generate separate script for Non-clustered and Clustered INdexes. Thanks

Vipul

Project License Changed

Thu, 31 May 2007 23:25:54 GMT

Microsoft Permissive License (Ms-PL) This license governs use of the accompanying software. If you use the software, you accept this license. If you do not accept the license, do not use the software. 1. Definitions The terms "reproduce," "reproduction," "derivative works," and "distribution" have the same meaning here as under U.S. copyright law. A "contribution" is the original software, or any additions or changes to the software. A "contributor" is any person that distributes its contribution under this license. "Licensed patents" are a contributor's patent claims that read directly on its contribution. 2. Grant of Rights (A) Copyright Grant- Subject to the terms of this license, including the license conditions and limitations in section 3, each contributor grants you a non-exclusive, worldwide, royalty-free copyright license to reproduce its contribution, prepare derivative works of its contribution, and distribute its contribution or any derivative works that you create. (B) Patent Grant- Subject to the terms of this license, including the license conditions and limitations in section 3, each contributor grants you a non-exclusive, worldwide, royalty-free license under its licensed patents to make, have made, use, sell, offer for sale, import, and/or otherwise dispose of its contribution in the software or derivative works of the contribution in the software. 3. Conditions and Limitations (A) No Trademark License- This license does not grant you rights to use any contributors' name, logo, or trademarks. (B) If you bring a patent claim against any contributor over patents that you claim are infringed by the software, your patent license from such contributor to the software ends automatically. (C) If you distribute any portion of the software, you must retain all copyright, patent, trademark, and attribution notices that are present in the software. (D) If you distribute any portion of the software in source code form, you may do so only under this license by including a complete copy of this license with your distribution. If you distribute any portion of the software in compiled or object code form, you may only do so under a license that complies with this license. (E) The software is licensed "as-is." You bear the risk of using it. The contributors give no express warranties, guarantees or conditions. You may have additional consumer rights under your local laws which this license cannot change. To the extent permitted under your local laws, the contributors exclude the implied warranties of merchantability, fitness for a particular purpose and non-infringement.

Source code checked in

nuanw — Sat, 21 Apr 2007 00:46:33 GMT

Uploading 'DBScript Utility'

UPDATED WIKI: DBScript Utility

nuanw — Thu, 22 Mar 2007 21:39:21 GMT

Script Utility

Introduction

This tool is focused on enhancing the data load process by removing the indexes on tables. While data is being inserted in tables which have indexes on them, the keys are added to the index. This could considerably slow down the data load process. Hence to perform a bulk load operation it would be faster to drop the indexes, load the data and rebuild the indexes.

The Script Utility wizard helps you to connect to a SQL Server instance, script the Indexes, foreign keys and triggers from the chosen tables in the database. It then generates create and drop scripts for those objects. These scripts could be run using tools like SQL Server Management Studio to drop the objects and re-create them once the data load is complete.

About the tool

It is a windows application written in C#, which uses SMO to connect to the relational database and script out the objects.

A lot of people have requested a need for this tool, primarily to perform the bulk data load process. The tool is selective in scripting objects. You could script just the clustered indexes, or all indexes from a small set of tables which are performing considerably slow in the data load process. It also provides scripts for foreign keys and triggers along with scripting the indexes.

Using the tool

Screen1:

• On the introduction screen click on the Next button.

Screen 2:

• This is the options screen where you setup the database connection settings and scripting options

Click on Edit
The connection properties window opens. Type in the Server name.
Choose the authentication mode.
Choose the database from the drop down list.
Click on Test connection to make sure you have permissions on the database.
Click on Ok.

• From the list of tables, choose the tables from which you want to script indexes.
• Choose the objects to be scripted (All Indexes/Clustered/Non Clustered, Foreign Keys and Triggers) and click on the Script button.

• The tool scripts all the selected objects from the chosen tables.
• Once the scripting is complete, click on View Script.

Screen 3:

• You can copy the script from this pane or have the tool save the script in a file.
• Click on the Back button.
• On the Options screen click on the Next button.

Screen 4:

• The list of tables and the objects that were scripted are shown in this page.
• Click on Save Script to save the script to a file.
• Click on Finish to exit.

Contact Information:

For further details/queries regarding this tool or to report bugs and issues mail to: syed.sameer@sonata-software.com

Source code checked in

nuanw — Thu, 22 Mar 2007 21:06:55 GMT

Update 'DBScript Utility.doc'

UPDATED WIKI: DBScript Utility

nuanw — Wed, 21 Mar 2007 21:57:36 GMT

Script Utility

Introduction

This tool is focused on enhancing the data load process by removing the indexes on tables.

The Script Utility wizard helps you to connect to a SQL Server instance, script the Indexes/related objects from the chosen tables in the database.

It then generates create and drop scripts for those objects. These scripts could be run using tools like SQL Server Management Studio to drop the objects and re-create them once the data load is complete.

Using the tool

Screen1:

• On the introduction screen click on the Next button.

Screen 2:

• This is the options screen where you setup the database connection settings and scripting options

Click on Edit
The connection properties window opens. Type in the Server name.
Choose the authentication mode.
Choose the database from the drop down list.
Click on Test connection to make sure you have permissions on the database.
Click on Ok.

Contact Information:

For further details/queries regarding this tool or to report bugs and issues mail to: syed.sameer@sonata-software.com

UPDATED WIKI: Home

nuanw — Wed, 21 Mar 2007 21:54:25 GMT

This project contains SQL Server Script samples contributed by Microsoft outside of the regular release cycle, MVPs, and other members of the community.

If you would like to contribute new sample scripts to this site or make contributions to samples already posted, Contact the Project Admin

Samples on this site include:

DBScript Utility

UPDATED WIKI: DBScript Utility

nuanw — Wed, 21 Mar 2007 21:52:55 GMT

Script Utility

Introduction

Using the tool

Screen1:

• On the introduction screen click on the Next button.

Screen 2:

• This is the options screen where you setup the database connection settings and scripting options

Click on Edit
The connection properties window opens. Type in the Server name.
Choose the authentication mode.
Choose the database from the drop down list.
Click on Test connection to make sure you have permissions on the database.
Click on Ok.

• From the list of tables, choose the tables from which you want to script indexes.
• Choose the objects to be scripted (All Indexes/Clustered/Non Clustered, Foreign Keys and Triggers) and click on the Script button.

• The tool scripts all the selected objects from the chosen tables.
• Once the scripting is complete, click on View Script.

Screen 3

• You can copy the script from this pane or have the tool save the script in a file.
• Click on the Back button.
• On the Options screen click on the Next button.

Screen 4

• The list of tables and the objects that were scripted are shown in this page.
• Click on Save Script to save the script to a file.
• Click on Finish to exit.

Contact Information:

For further details/queries regarding this tool or to report bugs and issues mail to: syed.sameer@sonata-software.com

UPDATED WIKI: DBScript Utility

nuanw — Wed, 21 Mar 2007 21:42:34 GMT

Script Utility

Introduction

Using the tool

Screen1:

• On the introduction screen click on the Next button.
Screen 2:

• This is the options screen where you setup the database connection settings and scripting options
o Click on Edit
o The connection properties window opens. Type in the Server name.
o Choose the authentication mode.
o Choose the database from the drop down list.
o Click on Test connection to make sure you have permissions on the database.
o Click on Ok.

• From the list of tables, choose the tables from which you want to script indexes.
• Choose the objects to be scripted (All Indexes/Clustered/Non Clustered, Foreign Keys and Triggers) and click on the Script button.

• The tool scripts all the selected objects from the chosen tables.
• Once the scripting is complete, click on View Script.
Screen 3

• You can copy the script from this pane or have the tool save the script in a file.
• Click on the Back button.
• On the Options screen click on the Next button.
Screen 4

• The list of tables and the objects that were scripted are shown in this page.
• Click on Save Script to save the script to a file.
• Click on Finish to exit.

Contact Information:

For further details/queries regarding this tool or to report bugs and issues mail to: syed.sameer@sonata-software.com

UPDATED WIKI: DBScript Utility

nuanw — Wed, 21 Mar 2007 21:39:47 GMT

Script Utility

Introduction

Using the tool

Contact Information:

For further details/queries regarding this tool or to report bugs and issues mail to: syed.sameer@sonata-software.com

UPDATED WIKI: DBScript Utility

nuanw — Wed, 21 Mar 2007 21:34:42 GMT

Script Utility

Introduction

Using the tool

Screen1:
Cannot resolve link: [image:example.gif]
• On the introduction screen click on the Next button.

Screen 2:

• This is the options screen where you setup the database connection settings and scripting options
o Click on Edit
o The connection properties window opens. Type in the Server name.
o Choose the authentication mode.
o Choose the database from the drop down list.
o Click on Test connection to make sure you have permissions on the database.
o Click on Ok.

• From the list of tables, choose the tables from which you want to script indexes.
• Choose the objects to be scripted (All Indexes/Clustered/Non Clustered, Foreign Keys and Triggers) and click on the Script button.

• The tool scripts all the selected objects from the chosen tables.
• Once the scripting is complete, click on View Script.
Screen 3

• You can copy the script from this pane or have the tool save the script in a file.
• Click on the Back button.
• On the Options screen click on the Next button.
Screen 4

• The list of tables and the objects that were scripted are shown in this page.
• Click on Save Script to save the script to a file.
• Click on Finish to exit.

Contact Information:
For further details/queries regarding this tool or to report bugs and issues mail to: syed.sameer@sonata-software.com

UPDATED WIKI: DBScript Utility

nuanw — Wed, 21 Mar 2007 21:34:01 GMT

Script Utility

Introduction

This tool is focused on enhancing the data load process by removing the indexes on tables.
The Script Utility wizard helps you to connect to a SQL Server instance, script the Indexes/related objects from the chosen tables in the database.
It then generates create and drop scripts for those objects. These scripts could be run using tools like SQL Server Management Studio to drop the objects and re-create them once the data load is complete.

Using the tool

UPDATED WIKI: Home

nuanw — Wed, 21 Mar 2007 19:39:11 GMT

Samples on this site include:

DBScript Utility

Source code checked in

nuanw — Wed, 21 Mar 2007 19:30:43 GMT

Upload 'DBScript Utility' sample

UPDATED RELEASE: 1.0 Beta

Wed, 21 Mar 2007 07:00:00 GMT

Add 'DBScript Utility' sample

UPDATED RELEASE: 1.0 Beta

Wed, 21 Mar 2007 07:00:00 GMT

Add 'DBScript Utility' sample

UPDATED RELEASE: 1.0 Beta

Wed, 21 Mar 2007 07:00:00 GMT

Add 'DBScript Utility' sample