MSSQL Deploy Tool Usage

This document will tell you how to use SQL Deploy Tool to configure Connection Information.

You can follow the steps below to complete the settings.

STEP 1: Fill connection string information.

STEP 2: Click “Test Connection” button for testing connection information.

STEP 3: Click “Execute” button for execution.

STEP 4: Exit application and check execution result.

  

 

STEP 1: Fill connection string information

The default connect string value would be loaded from Configuration.xml file. So you can modify the value in Xml file or in UI.

NOTE: Click here to learn Configuration.xml file format/schema.

In UI, you can type or paste entire connection string directly, or fill specific field values to generate connection string.

NOTE: Textbox for connection string and panel for specific field values would be impacted each other dynamically.

image

STEP 2: Click “Test Connection” button for testing connection information.

After clicking the button, you may get the popup dialog for telling you whether the connection is successfully.

If it is successful, you can get dialog like below:

image

NOTE: The text content in that dialog is about your target SQL Server version, so it may be different for each using.

If it is failed, you can get dialog like below:

image

NOTE: The text content in that dialog is about your error message. You can do troubleshooting according to that message. 

NOTE: If after you click the button, there is no reaction occurred, that may be the network issue or any other environment issue. Please be patient and waiting for the result. 

STEP 3: Click “Execute” button for execution.

After you click button for execution, you can see a MS-DOS based window like below image.

clip_image005[4]

The first five lines describe the combined and generated script location. And the following lines show the execution result.

In that case, you just need to press any key to exit to complete entire deployment.

NOTE: If you are interested in advanced settings and application workflow, please click here to see.

STEP 4: Exit application and check execution result.

Click “x” or “Exit” for exit the application.

 

 

clip_image006[4]

Last edited Apr 26, 2013 at 6:00 AM by rynnwang, version 11

Comments

No comments yet.