[google-cloud-sql-discuss] Re: Migrating from Cloud SQL to Datastore

Hi Sajid,

Unfortunately there is no automatic way to migrate a Cloud SQL database to Datastore.  The general process for migrating is as follows:

1. Map your relational model to datastore kinds and entities

2. [Optional] Download your relational database as csv

3. Write a script using one of our Cloud Datastore Client Libraries that would transfer your data from Cloud SQL or the csv in step 2 to Datastore

4. If you have a large database, it would speed up the migration process by hosting your script on App Engine.

If you require assistance in writing your script for migrating relational database to Datastore it is recommended to post your complete question to Stack Overflow using one of our supported tags, as your question will receive a lot more attention there.

I have found a useful post on Stack Overflow for you that I think might help you.

On Sunday, November 18, 2018 at 4:22:23 PM UTC-5, sajid saiyed wrote:

Hi,

I am currently using Cloud SQL but its an over kill for the small application that I moved from another host to Google Cloud.

I wanted to know how can I move my data from SQL to Datastore?

Is there an automatic way to do that?

It would be impossible to manually re-create the existing database in Datastore (100's of rows of sql data).

Any tips are appreciated.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/2bfe796e-c176-4da1-94fd-a5accc5b6b20%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.