Demo of installing and running DB query analyzer 6.03 on Windows 8, db6.03

Demo of installing and running DB query analyzer 6.03 on Windows 8, db6.03
 

Demo of installing and running DB query analyzer 6.03 on Windows 8

Magenfeng
(Guangdong Union Electronic Service Co., Ltd., Guangzhou 510300, China)

 

 

SummaryThis article describes in detail how to install and use the "universal database Query Analyzer", the Chinese version of "DB Query Analyzer", and the English version of "DB Query Analyzer" 6.03 on Windows 8.

Starting from version 6.01, the SQL "Execution Plan" function has been added to the Chinese and English versions of the universal database query analyzer. From version 6.02, you only need to set the option "SQL Execution Plan connection Automatic Recovery" in the "tool-à option" window to "selected" status, even if the database server goes down during the "SQL Execution Plan" period, as long as the database server processes the startup status at the time of the "SQL Execution Plan, the "SQL Execution Plan" will be executed.

The universal database query analyzer in both Chinese and English versions is fully compatible with any Microsoft Windows operating system series, including Windows 10, Windows 8, Windows 7, Vista, Windows XP, Windows 2000, Windows NT, Windows ME, and Windows 98. When running on a Windows operating system, you do not need to change any operating system settings.

KeywordsDB Query Analyzer

 

 

 

 

1 Introduction

Ma genfeng, a local programmer in China (Interview with Ma genfeng in CSDN: A Chinese programmer who is a master of massive data processing and analysis) Released personal work ---- universal database Query Analyzer, Chinese Version DB Query Analyzer and English version DB Query Analyzer. It has powerful functions, friendly operation interface, good operability, spanning a variety of database platforms and even EXCEL and text files.
 

You can use it①Query ODBC data sources (including all databases, TXT/CSV files, and EXCEL files in the world.② You can execute multiple DML statements and even the storage process at the same time, and the results will be returned in the table, text box, and file you set;③When exporting tens of millions of data records from a database, the efficiency is no different from that of DBMS;④With the powerful SQL "Execution Plan" function, you only need to set the option "SQL Execution Plan connection Automatic Recovery" in the "tool-à option" window to "selected" status, even if the database server goes down during the "SQL Execution Plan" period, as long as the database server processes the startup status at the time of the "SQL Execution Plan, the "SQL Execution Plan" will be executed;⑤Version 6.03 is fully compatible with any Microsoft Windows operating system series, including Windows 10, Windows 8, Windows 7, Windows Vista, Windows 2003, Windows XP, Windows 2000, Windows NT, Windows ME, and Windows 9X, which can be run directly on Windows OS, you do not need to change any settings or configurations of any operating system.
 

DB query analyzer is online in Zhongguancun (Http://xiazai.zol.com.cn/detail/27/264455.shtml) Downloads exceed 0.1 million times, ranking first 10 in the entire database category ranking.

 

In the "New Product & tool comments" section of "programmer" 2007, "Special Recommendation" was edited and the "universal database query analyzer" was released.
 

I also wrote about the related technologies of "universal database query analyzer ".75Article, published on "computer programming skills and maintenance", "software", "Computer Age", "computer programming skills and maintenance", Baidu Library, CSDN resources, and my blog (CSDN blog, Sina Blog, QQ space, and Sohu blog ).
 

This document takes the Chinese version DB query analyzer 6.03 as an example to describe how to install and run analyzer 6.03 on Windows 8.

 

 



 

2 6.03The Chinese version of DB query analyzer is used as an example.

The following uses the Chinese version of the "universal database query analyzer" database query analyzer 6.03 as an example to access CSV and TXT files on a Windows 8 PC.
 

Operating System: WINDOWS 8.1 Operating System

Foreground program: DB query analyzer 6.03

Background Database: CSV

 

 

Figure 1 Windows 8.1 Chinese operating system (1)

 

 

Figure 2 Windows 8.1 Chinese operating system (2)

 

 

 

 

Figure 3 install DB query analyzer 6.03 on Windows 8 (1)

 





 

Figure 4 install DB query analyzer 6.03 on Windows 8 (ii)

 





 

Figure 5 install DB query analyzer 6.03 on Windows 8 (iii)

 
 

 

How to obtain the Chinese version of "universal database Query Analyzer" DB Query Analyzer "and the English version of" DB Query Analyzer "in" Zhongguancun online"Source installation packageFor more information, see How to use the ZOL one-click installer to download the Zhongguancun online source installation package and How to download the installation package by ZOL Downer.

 

 



 

3 DBRun the query analyzer on Windows 8

 

Figure 6 ODBC data source created on the login system pointing to the. CSV/. txt file

 




 

Figure 7 execution of the query SQL statement in "DB query analyzer" (1)

 



 

Figure 8 execution of the query SQL statement in "DB query analyzer" (2)

 



 

Figure 9 Execution of the query SQL statement in "DB query analyzer" (3)

 





 

Figure 10 click "query-> Execution Plan" to open the "Execution Plan" Window




 

 

Figure 11 add an execution plan"

 

 

As long as the execution plan time is the past time, the SQL script will be executed immediately. When the "Automatic Recovery of SQL Execution Plan connections" option is selected, when the database connection is interrupted, the universal database query analyzer will restore the database connection.

Figure 12 execution plan in progress

 

Note:

The scheduling interval of the "Execution Plan" scheduler is 5 seconds, so the scheduled time is xx:Xx:01, but the execution start time is xx:Xx:01 and xx:Xx:Between 04.

 


 

 

4. I wrote 75 technical articles on "universal database query analyzer ".

 

Currently, the following six articles are published in several Chinese computer publications:

[1] Ma genfeng-DB Query Analyzer interrupted SQL statement execution · Hangzhou: computer age, Issue 1, 12th

[2] Ma genfeng-DB query analyzer executes DML statements in batches and returns more detailed information. · Beijing: computer programming skills and maintenance, Issue 1, 24th

[3] Application of Transaction Management in maingfeng DB Query Analyzer in DB2 · Beijing: computer programming skills and maintenance, Issue 1, 22nd

[4] Ma genfeng-DB query analyzer interrupted SQL statement execution · Tianjin: software, Issue 1, 6th

[5] Ma genfeng · Application of Transaction Management in Oracle in universal database query analyzer · Shanghai: "micro-computer application", Issue 1, 11th

[6] margenfeng New Product & tool comments Special Recommendation: "universal database query analyzer" released · programmer, Issue 2 in 2007

 

The following 69 articles are published on Baidu Library, CSDN resources, and my blog:

Tips for using the universal database query analyzer (1) until the use of the universal database query analyzer (16) 16 articles

The 1st tip of DB Query Analyze until The 16th skills of DB Query Analyzer contains 16 articles

How to configure ODBC on the client to access a remote DB2 for Windows Server

How to configure odbc dsn in Client to access remote DB2 for Windows

How to configure ODBC on the server to access the local DB2 for Windows Server

How to configure odbc dsn to access local DB2 for Windows

Top software developer killer SQL statements

Which SQL statement is the trump card to the senior software developer

DB query analyzer executes DML statements in batches and returns more detailed information

Using the universal database query analyzer to test SQLite's support for the four SQL statements

Use the Object Browser of the "DB query analyzer" to display the database data dictionary

Universal database query analyzer users have basically covered all current Database Systems

The DBMS that DB Query Analyzer Users often use cover all kinds of DBMS

Functions required by the query analyzer-interrupted query execution

EXE file shelling Technology for universal database query Analyzer

Exe packer prevent DB Query Analyzer from beging debugged

The self-developed "universal database query analyzer" has finally achieved great results.

DB Query Analyzer interrupt SQL statement execution

DB query analyzer executes DML statements in batches and returns more detailed information

Application of Transaction Management in DB Query Analyzer in DB2

DB query analyzer interrupts SQL statement execution

Application of Transaction Management in universal database query analyzer in Oracle

Special Recommendation: universal database query analyzer release

Four SQL statements that must be mastered by software developers (I)

Four SQL statements that must be mastered by software developers (II)

Four SQL statements that must be mastered by software developers (III)

Four SQL statements that must be mastered by software developers (4)

Four SQL statements that must be mastered by software developers (Comprehensive)

Summit ---- "universal database query analyzer" 5.01 released

Universal database query analyzer and EXCEL powerful combination for data analysis

DB query analyzer executes Multiple SQL statements in batches and views their respective execution times

When DB query analyzer accesses EXCEL, you must add brackets or double quotation marks before and after the table name.

The table name must be enclosed in double quotation marks or square bracket while accessing EXCEL by DB Query Analyzer

How to Use ZOL one-click installer to download the Zhongguancun online source installation package

How to download the installation package by ZOL Downer

DB query analyzer 6.03, the best database client tool on any Windows Operating System

DB Query Analyzer, the most excellent Universal database Access tools on any Microsoft Windows OS

DB query analyzer 6.03 installation and running demonstration on Windows 8

Demonstration of DB Query Analyzer 6.03 Installation and Running on Microsoft Windows 8

 

 

 

 

 

 

DB query analyzer 6.03 Zhongguancun online:

Http://xiazai.zol.com.cn/detail/27/264455.shtml

 

 

DB Query Analyzer 6.03 Zhongguancun online:

Http://xiazai.zol.com.cn/detail/43/420901.shtml

 

 

 

Note:

If your computer is installed with a version earlier than "universal database query analyzer", Uninstall the old version before installing the new version. Thank you!

 

 

 

Author profile:

Ma genfeng, Master, research direction: database application.

I have developed a universal database Query Analyzer. The Chinese version is DB Query Analyzer and the English version is DB Query Analyzer. It has powerful functions, friendly operation interface, good operability, spanning a variety of database platforms and even EXCEL and text files.

I have also developed a File Delete Absolutely to permanently Delete files in Windows without being recovered by other software.

These two software are free to use. They are downloaded from several major software download websites, such as Zhongguancun online, skysoftware station, huajun Software Park, Pacific computer, extraordinary software station, and green alliance.

 

 

Author's blog:

CSDN blog: http://blog.csdn.net/magenfeng

Sina Blog: http://blog.sina.com.cn/magenfeng

QQ space: http://user.qzone.qq.com/630414817