Sqlserver Toolbox (script sorting + Log clearing + more practical functions)

Sqlutility- toolbox

Software Description:

When SQL scripts are generated using sqlserver Enterprise Manager, the script sequence is not sorted according to the dependency of database objects. This bug causes the generated scripts to be unable to be executed directly. Developers must sort the scripts manually or find other alternatives, which increases the workload and troubles. The original reason for writing this tool is to solve the above problem. Since it has been written, we should share it with you. By the way, the transaction log clearing function was added before the release. If you have time and need it later, you are planning to add more practical functions. I hope this little tool can help you.

Running environment:

Because it is written in. net, you need to install the. NET runtime environment before running. This may cause some obstacles to the widespread use of this tool. Here, I am sorry for all the affected friends! If you do not have a. Net Running environment, please download one from the Internet.

I mainly conduct development and testing in sqlserver2000 Enterprise Edition,I hope you can help test, Report Bugs, or make suggestions. Welcome to my blog for discussion. Thank you!

Running Environment(23 m):

Http://www.microsoft.com/downloads/details.aspx? Familyid = 262d25e3-f589-4842-8157-034d1e7cf3a3 & displaylang = en

Http://www.ustc9703.com/download/get.asp? Id = 21 & type = 1 & url = 1

Http://cq.down.chinaz.com/down/NETFramework.exe

BenProgram:

Http://files.cnblogs.com/happyprogram/SQLUtility-v1.0-beta.rar

SQL script sorting:

·Before use, generate an SQL script in the sqlserver Enterprise Manager and save it as a file.

·Run this program, select a database on the main interface, and click "script sorting" to go to the sorting page.

·On the script sorting page, click "Browse" to select the generated file and click "start sorting ".

Clear transaction logs:

·Run this program, select a database on the main interface, and click "Clear log ".