0
votes

Is there any tools available for Oracle to Google Cloud Spanner migration? Also whether Spanner supports Stored Procedure, Views, Triggers, Function, etc ?

4
Is this a live migration (i.e., no downtime is a requirement) OR can you take downtime for the migration?eb80

4 Answers

2
votes

Cloud spanner does not yet support Stored Producer, Views, or Triggers.

1
votes

We are following this approach: Extract a csv for each table from Oracle database. We will place them in a bucket and run a dataflow job that will convert csv to avro and import them together into SPANNER maintaining the relationship Key points: You have to create schema in Spanner beforehand, try to have columns names and datatypes as close as possible to avoid too much work within Dataflow job.

0
votes

Cloud Spanner currently does not support these features. For migration, once the data can be read by Cloud Dataflow, the Cloud Spanner Dataflow connector can be used to import the data into Cloud Spanner.

0
votes

I think we should look for other approaches For migration, once data can be read by Cloud Dataflow, the Cloud Spanner Dataflow connector can be used to import data to Cloud Spanner. Also, read this article, it can help you understand Google Cloud Spanner migration