I made the same transition last year. Below is a sample script that I used
successfully
to have Oracle generate a file of SQL statements which can be read in to
sqlite with
.read. Obviously, this needs to be tailored to each table dumped.
If this script is called oracle-dump.sql, then run
a way to export your database is to generate the sql script database to a
file, and from sqlite type '.read path_to_file/file'
if it doesn't work try to change the sql script exported so it can be
understanded by sqlite for example delete stored procedure and change
triggers if any way you have
Hi,
I wanted to use the sqlite database. Currently I am using the oracle
database.
Is there any way to import the oracle database to sqlite database?
If so plz. tell me.
Thanks in advance.
With warm regards,
Amar
3 matches
Mail list logo