1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
|
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Data Migration</title>
<link rel="stylesheet" href="gettingStarted.css" type="text/css" />
<meta name="generator" content="DocBook XSL Stylesheets V1.73.2" />
<link rel="start" href="index.html" title="Getting Started with the Oracle Berkeley DB SQL APIs" />
<link rel="up" href="admin.html" title="Chapter 5. Administrating Berkeley DB SQL Databases" />
<link rel="prev" href="sync.html" title="Syncing with Oracle Databases" />
<link rel="next" href="bfile-extension.html" title="Appendix A. Using the BFILE Extension" />
</head>
<body>
<div xmlns="" class="navheader">
<div class="libver">
<p>Library Version 11.2.5.3</p>
</div>
<table width="100%" summary="Navigation header">
<tr>
<th colspan="3" align="center">Data Migration</th>
</tr>
<tr>
<td width="20%" align="left"><a accesskey="p" href="sync.html">Prev</a> </td>
<th width="60%" align="center">Chapter 5. Administrating Berkeley DB SQL Databases</th>
<td width="20%" align="right"> <a accesskey="n" href="bfile-extension.html">Next</a></td>
</tr>
</table>
<hr />
</div>
<div class="sect1" lang="en" xml:lang="en">
<div class="titlepage">
<div>
<div>
<h2 class="title" style="clear: both"><a id="datamigration"></a>Data Migration</h2>
</div>
</div>
</div>
<div class="toc">
<dl>
<dt>
<span class="sect2">
<a href="datamigration.html#shellmigrate">Migration Using the Shells</a>
</span>
</dt>
</dl>
</div>
<p>
If you have a database created by SQLite, you can migrate
it to a Berkeley DB database for use with the BDB SQL interface. For
production applications, you should do this only when your
application is shutdown.
</p>
<p>
All data and schema supported by SQLite can be migrated to a
Berkeley DB database.
</p>
<div class="sect2" lang="en" xml:lang="en">
<div class="titlepage">
<div>
<div>
<h3 class="title"><a id="shellmigrate"></a>Migration Using the Shells</h3>
</div>
</div>
</div>
<p>
To migrate your data from SQLite to a Berkeley DB database:
</p>
<div class="orderedlist">
<ol type="1">
<li>
<p>
Make sure your application is shutdown.
</p>
</li>
<li>
<p>
Open the SQLite database within the
<span class="command"><strong>sqlite3</strong></span> shell.
</p>
</li>
<li>
<p>
Execute the <code class="literal">.output</code> command to
specify the location where you want to dump data.
</p>
</li>
<li>
<p>
Dump the database using the SQLite
<code class="literal">.dump</code> command.
</p>
</li>
<li>
<p>
Close the <span class="command"><strong>sqlite3</strong></span> shell and open
the Berkeley DB
<span>
<a href="../api_reference/C/dbsql.html" class="olink">dbsql</a> shell.
</span>
</p>
</li>
<li>
<p>
Load the dumped data using the
<code class="literal">.read</code> command.
</p>
</li>
</ol>
</div>
<p>
Note that you can migrate in the reverse direction as well.
Dump the Berkeley DB database by calling <code class="literal">.dump</code>
from within the Berkeley DB
<span>
<a href="../api_reference/C/dbsql.html" class="olink">dbsql</a> shell,
</span>
and load it into SQLite by <code class="literal">.read</code> from within
SQLite's <span class="command"><strong>sqlite3</strong></span> shell.
</p>
</div>
</div>
<div class="navfooter">
<hr />
<table width="100%" summary="Navigation footer">
<tr>
<td width="40%" align="left"><a accesskey="p" href="sync.html">Prev</a> </td>
<td width="20%" align="center">
<a accesskey="u" href="admin.html">Up</a>
</td>
<td width="40%" align="right"> <a accesskey="n" href="bfile-extension.html">Next</a></td>
</tr>
<tr>
<td width="40%" align="left" valign="top">Syncing with Oracle Databases </td>
<td width="20%" align="center">
<a accesskey="h" href="index.html">Home</a>
</td>
<td width="40%" align="right" valign="top"> Appendix A. Using the BFILE Extension</td>
</tr>
</table>
</div>
</body>
</html>
|
