CYQ. DBImport database reverse engineering and batch import database tool V2.0 released [add batch Export Database scripts and database design documents]

Last release: CYQ. DBImport V1.0 Introduction: CYQ. DBImport reverse engineering and batch import database tool V1.0

 

This release of V2.0 is intended for overseas attacks. The following is a description of this release.

 

I. Introduction to new features of Version 2.0

 

1: fixed the GUID script error.

2: add processing. When the table for data import has no data, the table structure is also created. The original version needs to be manually created.

3: adds the where Condition for the table. You can set query conditions for the table to filter data.

4: added a custom view that allows you to use SQL statements to specify the data to be exported.

5: Add batch database script export [Highlight 1: Allow exporting arbitrary database version scripts from one database]

6. Added database design document output. [Highlight 2: Allow exporting any database design document from one type of Data]

 

Ii. usage instructions

 

1: Double-click CYQ. DBImport to run. In the displayed logon window, enter the account of the autumn garden to experience the new features of 2.0.

 

2: Follow the prompts to enter the user name and password, and click "Login" to log in.

 

3: Login successful. Jump to the main interface, similar to the V1.0 interface [only the following and several buttons are added]

 

4: Enter the database link, click "Connect", query and list the database tables, and the related buttons are activated.

 

5. New Function 1: Add a where filter statement to the table: select a table, enter the where statement in the input box below, and click "Add Where ".

 

PS: You can modify or remove a table after adding the table. Double-click the table and restore the table to the following input box. After deleting or modifying the table, submit the where statement.

 

6: New Feature 2: added extended custom view: allows the input of SQLViewStatement, and then click "Add mmview" to Add a new view chart under the table.

 

PS: You can also Remove the table. Select the table and click "Remove" to Remove the table. You can also add the where statement to the view.

 

7: Highlights function 1: Batch export table structure library Script: SwitchOptionGo to ViewDBSql, select the table to be exported, select the database Script Type [DalType] To be output, and click "Export SQL"

 

PS: By the way, let's take a look at the exported database structure. There are too many tables. Only the previous and later sections are taken, you know.

 

 

9: Highlights function 2: Batch Export of database documents: operations are the same as highlights 1. Click "Export Document" when everything is ready"

 

PS: a prompt will be displayed after the export is successful. The exported database design document contains too many tables and only the previous part is cut. After confirmation, the database document will be automatically opened.

PS: The SQL2005 link is entered in the Demo, and the MySql table structure document is output, for example.

 

PS: the output here is a Chinese document. To attack overseas users, you have to change some texts to E.

 

You are welcome to leave a message to plan your website .......

 

Original article of the autumn color Park: CYQ. DBImport V2.0 released [support for multiple types of database mutual data import/export of database scripts and database design documents]

 

: Http://www.cyqdata.com/download/article-detail-426