image

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        Creating a New Project 7

3.1.1         Adding a New Database Connection.. 8

3.1.2         Deleting an Existing Connection.. 8

3.2        Project Explorer 8

4        Database Explorer 10

5        Tables & Collections. 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. 19

8.5        Extensions. 19

8.5.1         Method Extensions. 19

8.5.2         Variables. 19

9        SQL Query Builder 21

10     JSON (BSON) Query Editor 22

10.1     Query Extensions. 22

11     SQL to MongoDB.. 23

12     LINQ Query Editor 24

12.1     Result Output 25

12.2     Linq to Entity Framework. 25

12.3     Linq to DataSet 25

13     Table Data View.. 27

13.1     Data Visualizer 27

13.1.1      Image Visualizer 27

13.1.2      Text Visualizer 27

13.1.3      Chart Visualizer 27

14     Data Editor 29

15     SQL Export 30

16     Data Export 31

16.1     General Options. 31

16.2     CSV Data Export 31

17     Data Import 33

17.1     Bulk SQL Import 33

17.2     CSV Data Import 33

17.2.1      CSV Import Options. 34

18     Data Search Engine. 35

18.1     Advanced Search.. 35

18.1.1      And / Or Operators. 35

18.1.2      Query Fields and Values. 35

18.1.3      Text (String) Operators. 35

18.1.4      Mathematical Operators. 36

18.1.5      Date and Time Operators. 36

18.2     Full-Text Search.. 37

18.2.1      Fuzzy Searching.. 37

19     Reporting.. 38

20     User Management 39

21     Entity Relations and ER Modeling.. 40

22     Host Information.. 41

23     System Reports. 42

24     Code Factory. 43

25     Maintenance. 45

26     Database Backup.. 46

27     Data Package Export/Import 47

27.1     Exporting Data Package. 47

27.2     Importing Data Package. 48

28     Options. 50

28.1     General Options. 50

28.1.1      List View.. 50

28.1.2      Data Paging Counter 50

29     Purchasing.. 51

30     Further Help.. 52

30.1     Bug Reports. 52

30.2     Feature Requests. 52

 

 

 


powered by Nucleon Software