SQLITE TO ORACLE

gmbrazzle · Post by **gmbrazzle** » Wed 09 Nov 2011 11:32

Since there are many options for this operation, I am looking to this forum for advice and to simply have others weigh in with their preference.

I have a number of mobile systems that collect data in local sqlite databases all across the country. I want to roll this data into a central repository through a web interface in which users will upload their sqllite file through a .net 4.0 aspx page. I want to use C# to pull each of the 100 or so tables in the sqlite file into arrays and pass the arrays as in mode parameter to Oracle stored procedures.

Inside the stored procedure, I will use PL/SQL to process the arrays into insert statements for the Oracle repository.

Do you think this is a good approach? What would you do?

Thanks.

Shalex · Post by **Shalex** » Thu 10 Nov 2011 09:03

This is a general question. We do not have such experience. If you encounter any provider-specific difficulties, please contact us.

gmbrazzle wrote:I want to use C# to pull each of the 100 or so tables in the sqlite file into arrays and pass the arrays as in mode parameter to Oracle stored procedures.

Inside the stored procedure, I will use PL/SQL to process the arrays into insert statements for the Oracle repository.

You can also parse the content of SQLite files in your .NET code and then use the OracleLoader class to pass the data to the Oracle database.