image

 

 

Nucleon Database Master           User Manual

 

 

 

 

 

 

Database Master is a product by Nucleon Software.

 


 

Table of Contents

1        Welcome to Database Master 4

1.1        Supported Database Systems & Connections. 5

1.2        System Requirements. 5

1.3        Server Requirements. 5

2        Getting Started.. 6

3        Project Management 7

3.1  7

3.2        Creating a New Project 7

3.2.1         Adding a New Database Connection.. 8

3.2.2         Deleting an Existing Connection.. 8

3.3        Project Explorer 9

4        Database Explorer 10

5        Tables, Collections and Documents. 11

5.1.1         Table Structure Editor 12

5.2        Indexes. 13

5.3        Triggers. 13

6        Views. 15

7        Stored Procedures. 16

8        SQL Query Editor 17

8.1        Executing a script 18

8.2        Output Window.. 18

8.3        IntelliSense. 18

8.4        Code Scripts and Templates. 19

8.5        Extensions. 19

8.5.1         Method Extensions. 19

8.5.2         Variables. 19

9        SQL Query Builder 21

10     MongoDB (JSON) Query Editor 22

10.1     Query Extensions. 22

11     C# Scripting.. 23

11.1     Result Output 24

11.2     Linq to DataSet 24

12     Table Data View.. 25

12.1     Data Visualizer 25

12.1.1      Image Visualizer 25

12.1.2      Text Visualizer 25

12.1.3      Chart Visualizer 25

13     Data Editor 27

14     SQL Export 28

15     Data Export 29

15.1     General Options. 29

15.2     CSV Data Export 29

16     Data Import 31

16.1     Bulk SQL Import 31

16.2     CSV Data Import 31

16.2.1      CSV Import Options. 32

17     Data Search Engine. 33

17.1     Advanced Search.. 33

17.1.1      And / Or Operators. 33

17.1.2      Query Fields and Values. 33

17.1.3      Text (String) Operators. 33

17.1.4      Mathematical Operators. 34

17.1.5      Date and Time Operators. 34

17.2     Full-Text Search.. 35

17.2.1      Fuzzy Searching.. 35

18     Reporting.. 36

19     User Management 37

20     Entity Relations and ER Modeling.. 38

21     Host Information.. 39

22     System Reports. 40

23     Code Factory. 41

24     Maintenance. 43

25     Database Backup.. 44

26     Data Package Export/Import 45

26.1     Exporting Data Package. 45

26.2     Importing Data Package. 46

27     Purchasing.. 48

28     Further Help.. 49

28.1     Bug Reports. 49

28.2     Feature Requests. 49

 

 

 


powered by Nucleon Software