mirror of
https://github.com/Wisser/Jailer.git
synced 2026-01-05 09:19:35 -06:00
253 lines
11 KiB
HTML
253 lines
11 KiB
HTML
<html xmlns="http://www.w3.org/1999/xhtml">
|
|
<head>
|
|
|
|
<title>Jailer - SQL Export</title>
|
|
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii" />
|
|
<meta name="description" content="Data Export Tool" />
|
|
<link rel="shortcut icon" href="favicon.ico" />
|
|
<meta name="keywords" content="data export referential integrity java jdbc dbms" />
|
|
<link rel="stylesheet" type="text/css" href="styles.css" />
|
|
</head>
|
|
|
|
<body left-margin="0" top-margin="0">
|
|
<div align="left">
|
|
<table style="text-align: left; position: absolute; left: 0pt; top: 0pt;" border="0"
|
|
cellpadding="0" cellspacing="0" height="407" width="100%">
|
|
<tbody>
|
|
<tr>
|
|
<td colspan="2" class="bannerbackground" height="33" width="100%">
|
|
<table border="0" cellpadding="4" cellspacing="0" width="100%">
|
|
<tbody>
|
|
<tr>
|
|
<td><a href="https://github.com/Wisser/Jailer"><img src="logo.png" hspace="10" /></td> <td class="slogan" width="100%"></a>
|
|
|
|
|
|
|
|
<td style="text-align: right; width: 100%;">
|
|
<table border="0" cellpadding="0" cellspacing="0">
|
|
<tbody>
|
|
<tr>
|
|
<td><a href="https://github.com/Wisser/Jailer"><img src="GitHub-Mark-64px.png" title="GitHub" /></a> </td></tr><tr style="height: 100%;"><td> </td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td colspan="2" class="nav1background" width="100%">
|
|
<b><font color="#FFFFFF"><a href="home.htm" target="_self" class=
|
|
"tlink"> Home </a> <a href="quicktour.htm" target="_self"
|
|
class="tlink"> Quick Tour </a> <a href="exporting-data.htm"
|
|
target="_self" class="tlinkA"> Tutorial </a> <a href=
|
|
"data-browsing.html" target="_self" class="tlink"> Data Browser </a> <a class="tlink" href="videos.html" target="_self"> Videos </a>
|
|
<a href="faq.html" target="_self" class="tlink"> FAQ </a>
|
|
<a href="api.html" target="_self" class="tlink"> API </a>
|
|
<a href="design.htm" target="_self" class=
|
|
"tlink"> Documentation </a> <a href=
|
|
"http://sourceforge.net/forum/?group_id=197260" target="_self" class=
|
|
"tlink"> Forum </a> <a href=
|
|
"http://sourceforge.net/project/showfiles.php?group_id=197260" target="_self"
|
|
class="tlink"> Download </a>
|
|
</font></b></td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td colspan="2" class="spacer" width="100%"></td> </tr><tr><td class="lmenucontainer"> </td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td class="lmenucontainer" height="100%" valign="top" width="14%">
|
|
<div align="center">
|
|
<center>
|
|
<table border="0" cellpadding="0" cellspacing="0" width="100%">
|
|
<tbody>
|
|
<tr>
|
|
<td height="6px" width="100%"> </td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</center>
|
|
</div>
|
|
|
|
<ul>
|
|
<li><a href="preparation.htm" target="_self" class="mlinkA">Preparation</a> </li><br>
|
|
|
|
<li>Basic</li>
|
|
|
|
<ul>
|
|
<li><a href="exporting-data.htm" target="_self" class="llink">Exporting Data</a> </li>
|
|
|
|
<li><a href="deleting-data.htm" target="_self" class="llink">Deleting
|
|
Data</a> </li>
|
|
</ul>
|
|
<br>
|
|
<li>Advanced</li>
|
|
|
|
<ul>
|
|
<li><a href="filters.html" target="_self" class=
|
|
"llink">Filters</a> </li>
|
|
<li><a href="subset-by-example.html" target="_self" class=
|
|
"llink">Subset By Example</a> </li>
|
|
<li><a href="exporting-xml.html" target="_self" class="llink">JSON/YAML/XML Export</a> </li>
|
|
</ul>
|
|
</ul>
|
|
|
|
<table border="0" cellpadding="5" cellspacing="0" width="100%">
|
|
<tbody>
|
|
<tr>
|
|
<td class="content2background"><img style="width: 160px; height: 1px;"
|
|
alt="" src="architecture-Dateien/vgradp.gif" /></td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
|
|
<p> </p>
|
|
</td>
|
|
|
|
<td class="contentbackground" height="418" valign="top" width="86%">
|
|
<div align="right">
|
|
<table border="0" cellpadding="0" cellspacing="0" height="542" width="98%">
|
|
<tbody>
|
|
<tr>
|
|
<td class="contentbackground" height="21" width="100%"> </td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td class="content" height="520" valign="top" width="100%">
|
|
|
|
<div class="info"><p> <br> If you do not want to prepare a database yourself, you can use the included "Demo-Scott" database instead. <br> </p></div> <br>
|
|
<h4>Step 1. Setup the database<br /></div></h4>
|
|
|
|
<p>Create a new database schema and execute <a href=
|
|
"scott-tiger.sql.html"><img style=
|
|
"border: 0px solid ; width: 13px; height: 13px;" src=
|
|
"exporting-data-Dateien/arrow.gif" hspace="4" /><big><span style=
|
|
"font-family: monospace;"><font size=
|
|
"4">script/scott-tiger.sql</font></span></big></a> . Make sure that
|
|
the script runs successfully.<br />
|
|
<br /></p>
|
|
|
|
<table style="width: 100%; text-align: left;" border="0"
|
|
cellpadding="0" cellspacing="0">
|
|
<tbody>
|
|
<tr>
|
|
<td style=
|
|
"vertical-align: top; background-color: rgb(230, 255, 230);">
|
|
<span style="font-family: monospace;">$ db2 connect to
|
|
wisser</span> <span style="font-family: monospace;">user
|
|
wisser</span> <span style="font-family: monospace;">using
|
|
<span style=
|
|
"font-style: italic;"><password></span></span><br />
|
|
<span style="font-family: monospace;">$ db2 -tvf
|
|
script/scott-tiger.sql<br /></span></td>
|
|
</tr>
|
|
</tbody>
|
|
</table><br />
|
|
|
|
<h4>Step 2. Building the data model<br /></h4>Start the Tool
|
|
(see <a href="installation-2.htm" target="_self">"Installation"</a> )<br><br />
|
|
|
|
<table style="width: 100%; text-align: left;" border="0"
|
|
cellpadding="0" cellspacing="0">
|
|
<tbody>
|
|
<tr>
|
|
<td style=
|
|
"vertical-align: top; background-color: rgb(230, 255, 230);">
|
|
<span style="font-family: monospace;">$ sh
|
|
jailerGUI.sh</span><br /></td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
|
|
<p>and create a new data model. Press <span style=
|
|
"font-style: italic;">New</span> and enter "Tutorial" as the name
|
|
for the new model.</p>
|
|
|
|
<p><img style="width: 697px; height: 280px;" alt="" src=
|
|
"screenshot4.1.gif" /><br /></p>
|
|
|
|
<p><br />
|
|
A data model holds information about the tables in the database and
|
|
all associations between them.<br />
|
|
Most of the information can be retrieved automatically by analyzing
|
|
the database schema.<br />
|
|
<br />
|
|
Click on <span style="font-style: italic;">Analyze
|
|
Database</span>.<br />
|
|
You will be asked for the database connection
|
|
information.<br /></p>
|
|
|
|
<p><img style="width: 655px; height: 328px;" alt="" src=
|
|
"screenshot4.2.gif" /></p>
|
|
|
|
<p>Create a new connection.<br /></p>
|
|
|
|
<p><img style="width: 409px; height: 316px;" alt="" src=
|
|
"dbs1.gif" /><br />
|
|
<br /></p>
|
|
|
|
<p>Select the DBMS you are using from the displayed list, and fill
|
|
out the following form:<br /></p><img style=
|
|
"width: 570px; height: 369px;" alt="" src=
|
|
"screenshot4.3.gif" /><br />
|
|
|
|
<p><br />
|
|
Finally click on <span style=
|
|
"font-style: italic;">Connect</span><span style=
|
|
"font-style: italic;">.</span> Jailer finds seven tables and five
|
|
associations:<br />
|
|
<br />
|
|
<img src="exporting-data-Dateien/screen3.png" /><br />
|
|
<br />
|
|
<br />
|
|
Two associations are still missing:<br /></p>
|
|
|
|
<ul>
|
|
<li>an employee is classified into a salary grade depending on
|
|
his salary</li>
|
|
|
|
<li>employees may receive bonuses</li>
|
|
</ul>
|
|
|
|
<br>
|
|
Add the definitions manually (<big><span style="font-family: monospace;"><span style="font-family: mon;"><span style="font-style: italic;">Add</span>-</span></span></big>Button under
|
|
<big><span style="font-family: monospace;"><font size="4">Associations</font></span></big>):<br>
|
|
<br>
|
|
<img src="exporting-data-Dateien/screen4.png"><br>
|
|
<br>
|
|
<img src="exporting-data-Dateien/screen42.png"><br>
|
|
<br>
|
|
The data model is now complete.<br>
|
|
<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>
|
|
<br />
|
|
|
|
<p><br /></p>
|
|
|
|
<p><br />
|
|
<br /></p>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
|
|
<p> </p>
|
|
</td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td height="12" valign="top" width="14%"><br /></td>
|
|
|
|
<td><br /></td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</body>
|
|
</html>
|