Android Question SQLite and SQL Server

Pilar-JLSineriz · Jul 20, 2015

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 · Jul 21, 2015

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

edgar_ortiz · Jul 21, 2015

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 · Jul 21, 2015

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

Pilar-JLSineriz · Jul 21, 2015

Erel said:
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 · Jul 21, 2015

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

edgar_ortiz said:
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 · Jul 21, 2015

Pilar-JLSineriz said:
have I develop code in B4J?

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

Pilar-JLSineriz · Jul 21, 2015

Erel said:
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 · Jul 21, 2015

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 · Jul 21, 2015

Erel said:
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

Android Question SQLite and SQL Server

Pilar-JLSineriz

Active Member

Erel

B4X founder

edgar_ortiz

Active Member

Pilar-JLSineriz

Active Member

Pilar-JLSineriz

Active Member

Pilar-JLSineriz

Active Member

Erel

B4X founder

Pilar-JLSineriz

Active Member

Erel

B4X founder

Pilar-JLSineriz

Active Member

Similar Threads

Android Question SQLite and SQL Server

Active Member

B4X founder

Active Member

Active Member

Active Member

Active Member

B4X founder

Active Member

B4X founder

Active Member

Similar Threads

Privacy & Transparency

Privacy & Transparency