RedGate tool SQLMultiScript1.1

The RedGate tool sqlmultiscript1.1sqlmultisate is a script distribution tool. After you write an SQL script, you need to execute it on many SQLSERVER servers. The tool is cracked: after installation, replace the following cracking file with the corresponding file in the installation folder and re-open the software.

The RedGate tool SQLMultiScript1.1 sqlmultisate is a script distribution tool. After you have written an SQL script, you need to use this tool to execute it on many SQLSERVER servers: after installation, replace the following cracking file with the corresponding file in the installation folder and re-open the software.

RedGate tool SQLMultiScript1.1

SQLMultiScript is a script distribution tool. After you write an SQL script, you need to execute it on many SQLSERVER servers.

You need this tool.

Cracked version:

After installation, replace the following cracking file with the corresponding file in the installation folder and re-open the software.

If you do not have this tool, you need to create a query on each SQLSERVER instance in the SQL version prior to SQL2012, And Then paste your script into the new query to execute

In this way, it is inconvenient to open multiple tab windows.

In SQL2012, you can create a folder (named folder o (Folder _ folder) o), and then run the SQL server instance to execute the SQL script.

In the folder, right-click the folder and choose "New query". A new query tab window is displayed, and the SQL script is put into the new query for execution.

Win7u-20130702m is my VM

Win7u-20130414z is my real machine

Both SQL2012 and SQL2012 have two problems.

(1) manually add SQLSERVER instances in the LAN to the folder one by one

(2) The master database is connected by default and cannot be selected. If my SQL script needs to be executed in the business database, it will not work.

SQLMultiScript can solve the above two problems

Before proceeding, let's take a look at SQLMultiScript cript's precautions.

(1) If the Firewall Service of the other party cannot be started and the firewall cannot be opened, SQLMultiScript cannot be connected to the other party's machine.

This is the same as SSMS. If SSMS can be used to connect to the other machine, SQLMultiScript cript can also be connected. If SSMS cannot connect to the other machine,

SQLMultiScript cannot be connected !!

(2) If you have only installed SQL2005 on your local machine, you cannot connect to and add the machine with SQL2012 installed, that is, if you need to control all

SQLSERVER instance. The SQLSERVER version of your local machine must be higher than the version of the distribution script you want to execute.

(For example, if your local machine is SQL2012, you can control SQL2000, SQL2005, SQL2008, SQL2008 R2, and SQL2012)

An error occurred while connecting SQL2012 with SSMS in SQL2005.

That is to say, the SSMS cannot be connected, and SQLMultiScript cannot be avoided.

Official start

Configure the database server to be connected first

It can automatically detect and display all SQLSERVER instances in the current LAN.

Configure which database server to connect to and which database is connected to the master database by default. If you do not expand the cross of the database server

Rename the SQL server group. The default name is "Default distribution list"

Because the win7u-20130702m of this computer is installed SQL2012, and my local machine is installed SQL2005, so the cross, can not add

You can see the added database server and the corresponding database. Here I select the master database.

Write or add an SQL script

We can create a New script, write the SQL statement by ourselves, or Add a written SQL script.

Remove selected scripts, Remove All scripts

We can use Parse Scripts to verify whether the script runs correctly on all database servers and whether there are syntax errors.

Click Exccute Now (F5) and the selected script will be executed (checked before the script). The unselected script will not be executed.

We can see that only Script 1 is executed, and Script 1 is