Migrate from SQL to NoSQL

[Marcela Guerrero]

Hi. Somebody can help me ? I need to migrate to SQL database working in PostgreSQL to ArangoDB.  If somebody could me recommend  some documentation about this . Thanks you.  

[filtered]

I think there is no automated way and in particular no generic way for moving a RDBMS setup to a document database.

Such a step always requires a detailed analysis of your current database and the business requirements for the future.

First question would be: why do you want or need to move away from a RDBMS? As said: when it comes to details, you need

to understand and decide yourself what ArangoDB would bring you, how you would model relations etc.

-aj

Am Sa., 22. Aug. 2020 um 22:22 Uhr schrieb Marcela Guerrero <marcelagu...@gmail.com>:

Hi. Somebody can help me ? I need to migrate to SQL database working in PostgreSQL to ArangoDB.  If somebody could me recommend  some documentation about this . Thanks you.  

--
You received this message because you are subscribed to the Google Groups "ArangoDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email to arangodb+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/arangodb/0da88f6e-8a50-48b0-ac0d-421e7f783603n%40googlegroups.com.

[Wilfried Gösgens]

Hi,

https://www.arangodb.com/why-arangodb/sql-aql-comparison/ has the language comparison AQL <-> SQL.

https://www.arangodb.com/docs/stable/aql/examples.html shows some common query types.

https://www.arangodb.com/docs/stable/graphs.html explains graphs with a special section for sql.

Please note as AJ suggests that there is no 1:1 conversion from a SQL database to a document store. You usually adjust your data model to remove denormalisations necessary for SQL.

Cheers,

Willi

Am Sa., 22. Aug. 2020 um 22:21 Uhr schrieb Marcela Guerrero <marcelagu...@gmail.com>:

Hi. Somebody can help me ? I need to migrate to SQL database working in PostgreSQL to ArangoDB.  If somebody could me recommend  some documentation about this . Thanks you.  

--

[Marcela Guerrero]

The reason I choose to migrate is because it is an academic type of activity. I only require information from someone who has already worked on it in this way or some documentation that may be useful to me, I would appreciate it.  

[Marcela Guerrero]

Thanks You