Howto export dbdata » Historie » Version 1
Jeremias Keihsler, 13.01.2017 14:06
1 | 1 | Jeremias Keihsler | h1. HowTo export data from DB |
---|---|---|---|
2 | |||
3 | * Open *DB Tools* aka @SQLProc@ |
||
4 | * goto menu @Windows/SQL Table Mass Dump@ |
||
5 | * you should get a screen like |
||
6 | |||
7 | !{width 500}sqlproc_massdump_1.png! |
||
8 | * click on @Load List@ |
||
9 | |||
10 | !{width 500}sqlproc_massdump_2.png! |
||
11 | * click on @select path@ |
||
12 | * create a new empty folder where to store data |
||
13 | ** @left click@ -> @new@ -> @folder@ |
||
14 | ** give the folder a name like @20120919@ |
||
15 | ** @double click@ on new folder |
||
16 | ** enter @File name@ = backup |
||
17 | |||
18 | !{width 500}sqlproc_massdump_3.png! |
||
19 | * click on @save@ |
||
20 | |||
21 | !{width 500}sqlproc_massdump_4.png! |
||
22 | * click on @Start@ |
||
23 | ** each table is individually saved, every table finished turns "green" |
||
24 | |||
25 | !{width 500}sqlproc_massdump_5.png! |
||
26 | * saving is completed when all tables turned "green" |
||
27 | |||
28 | !{width 500}sqlproc_massdump_6.png! |
||
29 | * close @SQLProc@ via menu @File/Exit@ |
||
30 | ** Answer @Close Application@ with **YES** |