Android Question SQLite and SQL Server

[Pilar-JLSineriz]

Hi,

I am working with APK developed in B4A and with a SQlite Database, is there a simple mode to open the SQlite database in SQL Server or I have to make a connexion by ODBC? Has B4A any library to save SQlite file as a SQL file that can be open directly by SQL Server?

Thanks

 

[Erel]

You can use B4J to read the data from the SQLite database and insert it into the SQL Server.

 

[edgar_ortiz]

Hi,

There is not a simple mode.

But you can check:

https://www.b4x.com/android/forum/threads/android-sqlite-viewer.9197/

http://www.sqlite.org/cli.html


And I can figure that you can "export" or "Dump" the SQLite database to MS-SQL Server.


Regards,

Edgar

 

[Pilar-JLSineriz]

Thanks.. I am going to try the Edgar code!

 

[Pilar-JLSineriz]

You can use B4J to read the data from the SQLite database and insert it into the SQL Server.

.. but.. have I develop code in B4J?

 

[Pilar-JLSineriz]

Hola Edgar

Si, tengo un fichero SQLite y lo que quiero es que lo lea SQL Server. He visto que el visor de SQL lo que hace es exclusivamente ver el contenido de la BD. Gracias

Hi,

There is not a simple mode.

But you can check:

https://www.b4x.com/android/forum/threads/android-sqlite-viewer.9197/

http://www.sqlite.org/cli.html


And I can figure that you can "export" or "Dump" the SQLite database to MS-SQL Server.


Regards,

Edgar

 

[Erel]

have I develop code in B4J?

Yes. You can write a B4J tool that will convert the SQLite database to SQL Server.

 

[Pilar-JLSineriz]

Yes. You can write a B4J tool that will convert the SQLite database to SQL Server.

Thanks Erel

Is there any example? it's the first time that I have to do something

 

[Erel]

Start with this tutorial: https://www.b4x.com/android/forum/threads/sql-tutorial.35185/#content

For further questions please start a new thread in the B4J forum.

 

[Pilar-JLSineriz]

Start with this tutorial: https://www.b4x.com/android/forum/threads/sql-tutorial.35185/#content

For further questions please start a new thread in the B4J forum.

Thanks Erel and sorry to use this forum